cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chipper
Helper II
Helper II

UTC to Excel date

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.

Chipper_0-1645325139085.png

Is there a string that can do this?

 

Thanks

Chip

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @Chipper ,

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



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

2 REPLIES 2
tom_riha
Super User
Super User

Hello @Chipper ,

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



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

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.

 

 Screen Shot 2022-02-25 at 8.08.01 AM.png

 

Thank you for the link and the help.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,682)