This time I’m walking through the remaining Date and Time functions. These include the functions that convert between and work with timezones: convertFromUtc, convertToUtc, convertTimeZone, utcNow. But first, we’re going to take a look at ticks. Just what the heck are ticks, anyway? Ticks are an integer value that represents […]
Tag: datetime
Function Friday – More Date and Time Fun: startOf and dayOf
Previously I’ve walked through how to do some date math, formatting, and parsing. Now I’ll drill into a few of the other date and time functions around getting certain values related to a particular date and time. There are three functions that are closely related: dayOfMonth, dayOfWeek, dayOfYear. All three […]
Function Friday – Formatting and Parsing Dates and Times
This week I’m looking at formatting and parsing date and time values in Power Automate. This can be a great pain when working with data in your functions for a straightforward reason: DateTime values come in many different formats. And different systems will require different formats for your DateTime values. […]
Function Friday: Date and Time Addition
This time I’m going to start delving into the date and time functions of Power Automate. Date and time is one of the most painful parts of working with flows. The reason for that is that sometimes a DateTime value is a DateTime, sometimes it’s a number, and sometimes it’s […]