Unanswered

Date format changes in excel

(0) Share

Report

Posted on by Community Power Pla...

I want to read a date in excel.

Then compare it when the date is 30 , 60 and 90 days from the current date, it will send out an email automatically based on the email provided in the excel sheet.

However, the date could not be read properly from excel and does not compare it from my expressions needed.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

BenjaminJarry 119 on at

Like (0)

Report

How do you store it into excel ?
(where / what format)

What is your if condition ? (should be "Exceldate is superior to adddays(utcnow(),30)" or like)

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report
Hi @Anonymous,

The return of Date column from Excel table is the days' number count from 1899-12-30, so if you want to compare it, you should use addDays() function to convert it into a correct date, for example:

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

One point that needs to notice is when you compare the date, the format should be 'yyyy-MM-dd', cause the compare starts from the beginning.

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.

Was this reply helpful? Yes No