Converting Excel Date Time Serial Values With Power Automate

A common issue I’ve run into and that I’ve heard others experience, is trying to use Excel DateTime values in Power Automate. You will encounter an error like below:

The reason this is an issue is due to the way Excel stores dates and times:

  • Dates are stored as a number representing the number of days since 1900-01-00
  • Times are stored as a fractional portion of a 24 hour day

Thus,…

Continue Reading ryanmaclean365’s Article on their blog

Converting Excel Date Time Serial Values With Power Automate

A common issue I’ve run into and that I’ve heard others experience, is trying to use Excel DateTime values in Power Automate. You will encounter an error like below: The reason this is an issue is due to the way Excel stores dates and times: Dates are stored as a number representing the number of…

Blog Syndicated with ryanmaclean365’s Permission

close

Author: Ryan Maclean

Share This Post On