Date and time Functions(Power Automate Cloud flows)
Date and time Functions
| Function | Overview |
|---|---|
| addDays | Adds the specified number of days to the date and time. Although not an unnecessary function, it is sufficient to unify date calculations with addToTime. |
| addHours | Adds the specified number of hours to the date and time. Although not an unnecessary function, it is sufficient to unify date calculations with addToTime. |
| addMinutes | Adds the specified number of minutes to the date and time. Although not an unnecessary function, it is sufficient to unify date calculations with addToTime. |
| addSeconds | Adds the specified number of seconds to the date and time. Although not an unnecessary function, it is sufficient to unify date calculations with addToTime. |
| addToTime | Add (calculate future dates) from the specified date and time in the specified unit. The subtractFromTime is the opposite of the positive and negative of the calculation. Units can be selected from year, month, week, day, hour, minute, and second. |
| subtractFromTime | Subtract (calculate past dates) from the specified date and time in the specified unit. The addToTime function is the opposite of the positive and negative of the calculation. Units can be selected from year, month, week, day, hour, minute, and second. However, since addToTime function is easier to understand and is the same as Excel and other calculation methods, it is acceptable to use addToTime instead of subtractFromTime. |
| convertFromUtc | Converts a date and time in Coordinated Universal Time to a specified time zone. Power Automate dates and times are often handled in Coordinated Universal Time (UTC), and you want to convert them to another time zone. |
| convertTimeZone | convertTimeZone is a function used in Power Automate expressions, It converts a date and time in Coordinated Universal Time (UTC) to a specified time zone. |
| convertToUtc | Converts the date and time in a time zone other than Coordinated Universal Time (UTC) to Coordinated Universal Time (UTC). |
| dayOfMonth | Extracts the day part from the date and time. |
| dayOfWeek | Determine the day of the week. |
| dayOfYear | Gets the number of days in the year for a given date and time. |
| formatDateTime | Converts a date and time to text in an arbitrary format. While parseDateTime is a similar conversion function, formatDateTime mainly converts date and time to text, parseDateTime mainly converts text to date and time. |
| getFutureTime | Add (calculate future date) from the current date and time (time zone is UTC) in the specified unit. Units can be selected from year, month, week, day, hour, minute, and second. It is similar to addToTime function, but there is a difference between calculating from the specified date and time or from the current date and time. This function is the reverse of getPastTime and the positive and negative of the calculation. |
| getPastTime | Subtract(calculate past date) from the current date and time (time zone is UTC) in the specified unit. Units can be selected from year, month, week, day, hour, minute, and second. It is similar to subtractFromTime function, but there is a difference between calculating from the specified date and time or from the current date and time. This function is the reverse of getFutureTime and the positive and negative of the calculation. |
| parseDateTime | Convert text that cannot be recognized as date/time into date/time format. This is used for date and time items in files created by applications other than PowerAutomate and data sent by e-mail, etc., which often cannot be used as date and time without modification. |
| startOfDay | Converts to date only by truncating the time portion (to 0:00:0:0) from the specified date and time. |
| startOfHour | Truncate the minutes and less from the date and time to only the date and time. (to make it 0 minutes and 0 seconds) |
| startOfMonth | Retrieves the first day of the month at the specified date and time. |
| ticks | Obtains the elapsed time since January 1, 0001 for the given date and time. The unit is 100 nanoseconds. It has few uses, but may be used for date serial calculations in Excel. |
| utcNow | Get the current date and time in Universal Coordinated Time. Similar to Current time Action |
---