Hi All,
Looking for a little assistance. I'm trying to convert our 'Date_completed' string from UTC to local time zone and in the format of 'YYYY-MM-DD'
Here's what I'm trying to convert.
Trying to take the pre-defined 'Date Completed' item inside 'Get_a_specific_audit' step, then trying to convert it with the format above.
I tried the following in the output of excel, however I get an invalid expressions.
formatDateTime(body('Get_a_specific_audit')?['audit_data']?['date_completed']),'YYYY-MM-DD')
formatDateTime(body('Get_a_specific_audit')?['audit_data']?['date_completed'],'YYYY-MM-DD')
Any help you all can provide, would be greatly appreciated.
------------------------------
Joshua Yeamans
Product Specialist
Kansas City MO
9135751209
------------------------------