Datetime Field Values

Refer to the information below to know how your data is transformed when you select a particular date and time format.

Year

Represents the year value of a date-time field.

Month

Represents the month value of a date-time field. Its value starts from 0, indicating the month of January.

Week of year

Represents the week number within the current year. Its value starts from 1, indicating the first week of the year.

Week of month

Represents the week number within the current month. Its value starts at 1.

Day of month

Represents the day number within the current month. Its value starts from 1.

Day of year

Represents the day number within the current year. Its value starts from 1. For example, the Day of year for 5th February equals 36.

Day of week

Represents the day of a week. Its value starts with Sunday.

Day of week in month

Represents the ordinal number of the week of the month in which the day falls. Its value starts at 1. Day 1 of the current month is treated as the start of the week, and all days within a given week return the same value. For example, the day of week in month for 1st to 7th of March is 1, for 8th to 14th of March it is 2, and so on.

Hour

Represents the hour of morning or afternoon in a 12-hour clock. The value ranges between 0 and 11. Noon and midnight are treated as 0.

Hour of day

Represents the hour of the day in a 24-hour clock. The value ranges between 0 and 23.

Minute

Represents the minute within the current hour. The value ranges between 0 and 59.

Second

Represents the second with the current minute. The value ranges between 0 and 59.

Millisecond

Represents millisecond within the second. The value ranges between 0 and 999.