You’re offline. This is a read only version of the page.
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.
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:
Share
Report
All responses (
Answers (
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.
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)
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
