Date and time Functions(Power Automate Cloud flows)

09/15/2023

Japanese version.

Date and time Functions

FunctionOverview
addDays
addHours
addMinutes
addSeconds
addToTime
subtractFromTime
convertFromUtc
convertTimeZoneconvertTimeZone 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
dayOfMonth
dayOfWeek
dayOfYear
formatDateTimeConverts 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
getPastTime
parseDateTimeConvert 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.
startOfDayConverts to date only by truncating the time portion (to 0:00:0:0) from the specified date and time.
startOfHour
startOfMonth
ticks
utcNowGet the current date and time in Universal Coordinated Time.

---

Links

Functions