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
"$filter": "@{formatDateTime('Start_x0020_Date','yyyy-MM-dd')} GE @{triggerBody()['date']}"
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