Forum Discussion

Iron Contributor

Aug 06, 2016

Solved

Issue with creating DateTime Condition in Microsoft Flow

I am trying to create a recurring Flow which checks the difference between a date field [ContractEndDate] and variation from todays date. If ContractEndDate is less than (todays date + 15 days) ...

Microsoft Flow

sharepoint

Mike Platvoet
Aug 07, 2016
The adddays function returns a string (iso date format), but the first part of your less function contains a date format that has not been formatted yet, so I suspect that the string compare does not give a proper result.
You should format the ContractEndDate to the same string format as the calculated date to have the Less function work as expected.

Mike Platvoet

Steel Contributor

Aug 08, 2016

Great! Thanks for flagging it as the correct answer.

Ivan PELORSON

Copper Contributor

Jan 25, 2018

Hi,

I am using the SQL Server Get line action and would like to compare the date of creation of a line in a table (field CREDAT_0) with the current date and be able to send an email when the creation date is today.

I have tried to convert the utcnow to the exact same format as my sql date but my flow keeps failing (no need to mention I have tried it without the condition and it works, that is to say it retrieves all the lines in the table).

Here is the sql date format and the condition I have put in place.

Thanks in advance for your kind help

addDays(utcnow('yyyy-MM-dd HHmm:ss.fff',0, 'yyyy-MM-dd HHmm:ss.fff'))"