In this blog, we will check how we can add and subtract an ‘x’ time unit such as second, minute, hour, day, week, month, and year into and from the existing date.
We have a client requirement in which, they want to calculate the next follow-up date for the current customer. This operation is performed when a new Customer (Account) is to be added to CRM and customer details are to be updated in the CRM.
To achieve the above user requirement we have designed a Power Automate flow that triggers the creation of an account and modification of the same. We have used addToTime() function for this. On firing this flow, the CreatedOn field of the account is read and the addToTime() function gets applied to it. The output value gets updated in the “Next follow up” file which is filled on the account form. Please find the below syntax for the function:
- DATE_TIME_VALUE: It states the Date Time value in which the time is to be added
- INTERVAL_TIME: It represents the numeric number that defines how many seconds, minutes, hours, days, weeks, months, and years that are to be added to the date
- TIME_UNIT: This defines which time unit (second, minute, hour, day, week, month, year) needs to be added to the existing date time
- OUTPUT_DATE_FORMAT: It shows the string date format in which the output of the date is to be seen
Here, we notice that one week is created on the field of Account entity and displayed on the account entity form:
Also, we can subtract second, minute, hour, day, week, month, and year from the existing date-time using the following-
On firing the Power Automate flow we get the following result-
Thus, in this manner, using subtractFromTime() and addToTime we can add or subtract second, minute, hour, day, week, month, or year time intervals from the existing date.