Datetime Field Values
ON THIS PAGE
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.