Changes

Jump to: navigation, search

Using Date Criteria

132 bytes removed, 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 DATE_FORMAT([this], '%W, %M %D') -- Thursday, November 5th  DATE_FORMAT([this], '%h:%i %p') -- 11:45 AM - 02:00 PM{{ReportBuilderDateFormatOption}}
{{PrevNextStart}} [[Prompting for a Criteria using a Wildcard]]
{{PrevNextMid}} [[Using Date Translation in Reports]]{{PrevNextEnd}}
[[Category:Reports]][[Category:Criteria]][[Category:Date Formats]]
8,849
edits

Navigation menu