UTC to Excel date

[Chipper]

I am trying to convert UTC to the date string that Excel produces so I can tell if an email should be sent or not on a particular day each month.

I have seen several post that would take the date from excel and convert it to a local time, but I was hoping to do it the other way around.

Is there a string that can do this?

Thanks

Chip

[tom_riha · Accepted solution]

Hello @Chipper ,

I described the calculation from the other side in a blog post.

[Chipper]

This is what I ended up using.

In the compose 2 section, I was able to use this.

div(sub(ticks(body('Convert_time_zone')), ticks('1899-12-30')), 864000000000)

And it worked in giving me the number I was looking for.  However, although it gave me the number, I assume it was in a format that I couldn't use.  I decided to use the Format Number function to put the number into a Text?? format.

So far so good.

 

Thank you for the link and the help.