You are here: Building Expressions > Dates and Times > Date and Time

Date and Time

Analyzer can also interpret combined Date and Time fields. Though the Data Definition Wizard will not automatically detect combined Date and Time fields, they can easily be defined by specifying a combined DateTime format. The rules for specifying the combined DateTime format and for displaying the combined Date and Time fields are the same as described for individual dates and times.

Note: When comparing a datetime field to a date with no time component, the missing time portion is assumed to be midnight (00:00:00).

Note: To indicate a 12 hour clock, the time format should include either a “p” or a “pm”.