Tip #1452: Compare dates in Power Automate
Always use `formatDateTime(), substring(), convertFromUtc(), convertTimeZone()` to drop the time part and ensure the dates are in the same timezone. The datetime in Power Automate is just a string representation of a timestamp in an ISO format. To compare dates, it's important to consider timezones and extract only the date portion. Functions like `formatDateTime(), substring(), convertFromUtc(), convertTimeZone()` can help with this. Timezones can be tricky, so it's helpful to refer to the list of default time zones provided by Microsoft.
Article 13m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time