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

(0) Share

Report

Posted on by PranavPh

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

All responses (1)

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

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

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