Datetime Field Values

This section describes the DateTime units that you can use to provide the settings in the Change DateTime Field Values Transformation.

Note: A positive value is added whereas a negative value is subtracted from the existing datetime value.

The following image illustrates the datetime units that Hevo currently supports:

Refer to the following table to know more about each Datetime unit:

DateTime Unit	Description
Year	Represents the year value of a date-time field. Its value starts from 1.
Month	Represents the month value of a date-time field. Its value starts from 1, 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 from 1, indicating the first week of the month. For example, the week of Dec 1-3, 2022 has the value 1, while the week of Dec 4-10, 2022 has the value 2. Now, suppose the date is Dec 30, 2022. The week value for this = 5. If you create a Transformation to add 1 Week of Month to it, this changes the date to Jan 6, 2023.
Day of month	Represents the day number within the current month. Its value starts from 1, indicating the first day of the month.
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 from 1, indicating the first day of the week, Sunday.
Day of week in month	Represents the ordinal number of the week of the month in which the day falls. Its value starts from 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. When you add or subtract a day of week in month value from a date, it advances or retracts the date by that many weeks. For example, in Thu Dec 01 00:00:00 UTC 2022, the Day of week in month = 1. If you subtract 1 Day of week in month, the resulting date becomes Thu Nov 24 00:00:00 UTC 2022.
Hour of day	Represents the hour of the day in a 24-hour clock. Its value ranges between 0 and 23.
Minute	Represents the minute within the current hour. Its value ranges between 0 and 59.
Second	Represents the second within the current minute. Its value ranges between 0 and 59.
Millisecond	Represents milliseconds within the second. Its value ranges between 0 and 999.