Datetime Field Values

Last updated on Jan 04, 2023
On This Page

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

Example of DateTime Units using Day of week in month

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:

All DateTime Units Supported


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.



Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jan-04-2023 NA enhanced the descriptions with examples.
Oct-25-2021 1.74 - Updated the page for readability and usability.
- Removed the Hour DateTime Unit as it is merged with the Hour of day DateTime Unit.

Tell us what went wrong