web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate convert string 1900-01...

Power Automate

Answered

convert string 1900-01-01T00:00:00.0000000Z to datetime and compare

(0) Share

Report

Report

Posted on by PranavPh

12

Hi, I'm storing datetime in text format as environment variable: 1900-01-01T00:00:00.0000000Z

In the flow, I'm reading a file and extracting datetime stamp. Now I want to compare the datetime from the file and update the environment variable if its greater. I'm facing issues in converting the text to the datetimestamp.

1. Datetime being read from the flow

Need help in the conversion and then just want to compare if date1 > date2 then.. action.

Regards,

Pranav

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PranavPh,
Do you want to convert the string to datetime stamp, and compare them?
I did some text according to your requirements.

Following is my flow.
1. You can use formatDateTime() function to convert the datetime if the string date match ISO 8601.

formatDateTime(variables('Date string'),'yyyy-MM-ddThh:mm:ss')

Best Regards,
Kyrie

Was this reply helpful? Yes No

Join the conversation