Changes

Jump to: navigation, search

Using Date Criteria

5 bytes added, 16:13, 30 August 2013
no edit summary
{{SeqReportPageHeader}}
 
All Date/time fields are stored in [[SmartSimple]] in the same field type – '''Date/Time'''. This means that when you are working with fields of this type, you need to deal with a value that contains both the date and the time stored in a single value.
=Report Builder Date Format Option= Under Calculated Field section, you can use the following format for a date field{{ReportBuilderDateFormatOption}}
DATE_FORMAT({{PrevNextStart}} [this[Prompting for a Criteria using a Wildcard]]{{PrevNextMid}} [[Using Date Translation in Reports]], '%W, %M %D') -- Thursday, November 5th {{PrevNextEnd}}
DATE_FORMAT([this], '%h:%i %p') -- 11:45 AM - 02:00 PM
[[Category:Reports]][[Category:Criteria]][[Category:Date Formats]]
Arthur Lathrop
8,849
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/9937...18328’

Navigation menu