Unanswered

Date comparison and ticks

(0) Share

Report

Posted on by JenkinsM

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
hjaf 486 on at

Like (0)

Report

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.

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).

Was this reply helpful? Yes No