Data Type

In Parser Management, you can set the data type for each column. There are four data types:

The format string expressed as following:

Expression Character Description
Year Y Year with century, as decimal number
y Year without century, as decimal number (00 – 99)
Month m Month as decimal number (01 – 12)
B Full month name
b Abbreviated month name
Day d Day of month as decimal number (01 – 31)
Time H Hour in 24-hour format (00 – 23)
h Hour in 12-hour format (01 – 12)
M Minute as decimal number (00 – 59)
S Second as decimal number (00 – 59)
s Millisecond as decimal number (000 – 999)
p A.M./P.M. indicator for 12-hour clock

When the format string uses “B”/”b” to descript Month, be sure the language is chosen properly. If there is no proper language presented, you can click 'Setup…' to create a set of month name in other language.

Tip: If the example in Date & Time Format dialog is not the same with the column content, the data type won’t be recognized correctly, which may affects the filtering result.

Copyright©Marmot Studio, 2012