Remove hour, minute, second from string

[Liminity_Sammy]

Hello,

I'm currently working on a Flow which uses data from API and I'm a bit stuck.

The flow calls to my API and I parse JSON. Here I get a string called "updated-at". "updated-at" equals a date in this format "2020-07-07T12:03:24.290+02:00"

I then have a condition saying if "updated-at" equals formatDateTime(utcNow(),'yyyy-MM-dd') then continue.

The problem is Flows is failing here since "updated-at" shows like this: "2020-07-07T12:03:24.290+02:00"

I would need to remove hours, minutes and seconds somehow from "updated-at" for the Flow to work. 

I appreciate all help!

Kind regards
Sammy

[Mira_Ghaly]

Hi @Liminity_Sammy

Have you tried formatting updated at in a compose or variable the same way you are formatting utcnow(), and then do the comparison between ur formatted updated at and the formatted UTC Now.

IF this solves your problem please mark my reply as a solution 

[Liminity_Sammy]

Hello Mira and thanks for your answer,I'm a bit of a novice here. I dont know hwo to do this. Do I need to change my 

formatDateTime(utcNow(),'yyyy-MM-ddT')? 

[v-litu-msft · Accepted solution]

Hi @Liminity_Sammy,

If you want to compare two dates, you should convert them into the same format, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Liminity_Sammy]

This works! Thank you very much!!!