Date Formats

When you define the DateTime format for a date field, you tell Analyzer which characters represent the day, the month and the year. Analyzer uses the following format characters to represent the elements of a date field:

Put separators such as the slash symbol (/) in the same relative position as they are in the source data file. If you do not, Analyzer will not interpret the date correctly. The format that you define must match the format of the stored date.

The following table shows different ways in which a date may be stored in a table and how you would describe the format to Analyzer.