Answered

Condition returns False when comparing Dates from Excel

(0) Share

Report

Posted on by JR-20121253-0

This is a bit of an odd one as I've solved the problem but I don't understand A) why its a problem or B) if I did the right thing...

Daily pull dates from Excel table and if they are 30 days from now send an email if not do nothing.

Entire Flow:

Compose:

formatDateTime(addDays('1899-12-30', int(item()?['Calibration Expiry Date']), 'yyyy-MM-dd'),'yyyy-MM-dd')

Condition:

outputs('Compose') is equal to formatDateTime(addDays(utcNow(), 30), 'yyyy-MM-dd')

Now what I don't understand is this would always return false even though the dates looked the same (I added an extra compose to check my Condition date) until I added the formatDateTime to both the Compose and Condition??

Am I doing something wrong or is this just now PA interacts with Excel dates? (although in my mind that makes no sense for the Condition to also need the formatDateTime)

Thanks,

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Re: Condition returns False when comparing Dates from Excel

Hi @JamesRobsonBio ,

Please select ISO 8601 format in List rows present into table.

Use this expression on the right side of condition:

formatDateTime(item()?['Calibration Expiry Date'],'yyyy-MM-dd')

Use this expression on the left side of condition

addDays(utcNow(),30,'yyyy-MM-dd')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JR-20121253-0 on at

Like (0)

Report

Re: Condition returns False when comparing Dates from Excel

Hi,

Made those changes and getting the following:

just to confirm changes made:

Thanks,

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Re: Condition returns False when comparing Dates from Excel

Hi @JamesRobsonBio ,

This error means that you did not select the ISO 8601 format in List rows present into table.

Please make sure you select the ISO 8601 format.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JR-20121253-0 on at

Like (0)

Report

Re: Condition returns False when comparing Dates from Excel

I selected this in the Parameters section of the List Rows do I need to do it elsewhere?
Or is my compose section now incorrect now I've changed that (although I don't see us referencing it any more?)
formatDateTime(addDays('1899-12-30', int(item()?['Calibration Expiry Date']), 'yyyy-MM-dd'),'yyyy-MM-dd')

Thanks,

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report
Re: Condition returns False when comparing Dates from Excel

Hi @JamesRobsonBio ，

Please re-create the flow and switch to classic designer.

I did a test for your reference.

In my scenario:

formatDateTime(items('Apply_to_each')?['Due'],'yyyy-MM-dd') addDays(utcNow(),30,'yyyy-MM-dd')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
JR-20121253-0 on at

Like (0)

Report

Re: Condition returns False when comparing Dates from Excel

Thanks for the breakdown, for some reason I'm still getting the same error:

and the only way I can get around it is by changing my compose step to
addDays('1899-12-30', int(item()?['Calibration Expiry Date']), 'yyyy-MM-dd')
I wonder if its my source data that's causing the issue?? I'll create a new test file and try the above solution, if it works I'll make the thread as resolved.

Thanks,

Was this reply helpful? Yes No