Setting a date variable

[lwine]

Hi,

I am working on a flow that creates and updates planner task details with a list of information. One piece of information is a date. I initialized the variable as a string and set the variable. See attached. When I update the task details, I use the FormatDateTime expression and use the variable. formatDateTime(variables('xlsxHireDate'),'yyyy-MM-dd') When I test the flow, it fails.

Additional details: I use scope control to combine my steps for error handling. It appears I cannot initiate a variable within a scope.  

Thanks for the help!
Initialize variableSet variableExpressionError

[ekarim2020 · Accepted solution]

When reading the Excel file, please set the DateTime Format to ISO 8601

Excel stores the date as integers, in a string. Selecting ISO 8601 should convert the data to a date type.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[lwine]

Thank you! That worked!