Hi everybody
in a Excel file I have a data so format 4/13/24 16:30 PM (m/dd/yy and Time)
I need to convert it i 'yyyy-mm-dd' only date without time
I have put this to filter the file
but I get this error:
'In function 'formatDateTime', the value provided for date time string 'Start_x0020_Date' was not valid. The datetime string must match ISO 8601
Many thanks
No, so easy😂
to fix I have create a filter (@and(greaterOrEquals(formatDateTime(item()?['Start Date'], 'yyyy-mm-dd'), formatDateTime(triggerBody()['date'], 'yyyy-mm-dd')), lessOrEquals(formatDateTime(item()?['Start Date'], 'yyyy-mm-dd'), formatDateTime(triggerBody()['date_1'], 'yyyy-mm-dd')))
and un SELECT to get only value that I want
Many thanks ScottShearer for suggest