web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Date comparison and ticks
Power Automate
Unanswered

Date comparison and ticks

(0) ShareShare
ReportReport
Posted on by 2
I have a flow that is always triggering because where it compares two dates, one date was calculated using ticks, and the other is a date pulled from SharePoint. It took me a while to figure out that the two will never be equal as long as it is looking at milliseconds. Is there a way to convert the ticks to a date without any "loose change" in the form of ticks?
Categories:
I have the same question (0)
  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @JenkinsM 

    Hi there!  Since there are 864 Billion ticks in a day (I've counted), you can divide the number of ticks by that to get the number of days since 1 Jan 1601... but it might be easier format both dates before your date-checking step to whatever you want.  Here's a blog on date math, if that helps.

     

    If you'd rather count the days since NYD 1601, then the formula will look like this: DIV(ticks(body('Convert_Due_Date_to_UTC')) ,864000000000)   - the stuff in red will be your Flow Date.

    Keep us posted.

    -Ed-

     

     

    If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

  • hjaf Profile Picture
    487 on at

    this is a bit confusing, i keep seing different dates being thrown around and there is no comment about this in the documentation for the expression.

     

    image.png

     

    the documentation is somewhat unclear, it may be obvious for the C# /.net devs working on power automate itself, but the end-user for power automate often have to deal with a plethora of time handling conventions. e.g. excel serialized time which starts at 1900-01-01 (ps if excel serial is to be used with addDays, then use 1899-12-30).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard