You’re offline. This is a read only version of the page.
I have excel data and it has the date column of created.
Its in power automate.I'm using excel as connector. I used the formula for adddays('1899/12/30',int(item()?['Created']),'yyyy/MM/dd') is not working it says the template language int is invoked.value cannot be converted as target type.
I used the other formula for
Please format the column with the Date option. I think it is currently set to General
Why is Excel Changing Dates to Random Numbers? | Date Changes to 5 Digit Number - YouTube
I put the same in iso format in list rows but all of my date column is changed into iso format except one column is like 45096 this format. so if i'm trying to formatdatetime(item()?['Accepted'],'MM/dd/yyy')
it throws an error string doesn't match the iso format.
Could you please tell me how to overcome this?
If you add item()?['Created'] in a compose message what does it print?
I need to filter the older 60 days of record (created Column) from current date.
Later i need to check the date difference between created to completed .
If i put that option in list rows then i'm trying to format the date as formatdatetime(item()?['Created'],'MM/dd/yyyy') it throws an error that is not iso format.
When querying data from excel, set the Date time format to ISO 8601.
What is your logic behind adding days?
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (