You’re offline. This is a read only version of the page.
Hi
Im trying to format the date from the list rows where the date field is coming as 2022-01-01T00:00:00Z , and this throws error on conditions
Scenario: i had field start date in one table
Start date in another table, but when the date is same it fails
As one come as 2022-01-01T00:00:00Z and another as
Hi @Ashwinreddy ,
Can You Show Me Screenshot of action in edit mode where you try to formatDateTime.
If You are Using List rows present in a table of Excel Online Action, Then You Have to Set DateTime Format.
Hi @Ashwinreddy ,
In the Condition control, you can use a formatDateTime expression to format all dates as 'yyyy-MM-dd'
Share
Report
All responses (
Answers (
formatDateTime(ExcelDateField,'yyyy-MM-ddT00:00:00Z')
Best regards,
#1
WarrenBelz
146,596
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
