Hi there,
I am pulling in the date from an excel file and have to convert it to a string so I can pass it back to PVA.
The issue is the month keeps changing to 00?
In the format date and time I have ,'dd/mm/yyyy') at the end of the expression.
The day and year is correct, why is the month going screwy?
formatDateTime(outputs('Get_a_row')?['body/Last modified Date'],'dd/mm/yyyy')
That's the expression. I can't upload pics for some reason, I click the icon and nothing happens.
When I do the test, the get a row pulls in the correct date, but the output from the initialise variable is 28/00/2021 for example as opposed to 28/09/2021
