Json Date and Time formation

[Anonymous]

Hi everyone.

I am having trouble to format the Json date and time which comes from an Rest Api. Format is just like this “ 2020-03-29T01:35:10Z ” . Basically I want to convert it Like “ DD-MM-YY and Time ”

eg: 29/03/2020 - 01:35PM

Thanks for the help in advance.

[ahmedoye]

Hi @Anonymous , could be due to some regional settings from you computer. Try this work-around.

First ensure the column is currently not showing error. (You may have to delete any "changed type" query step from your "Applied Steps". Then:

1. Click on the Icon beside the column header
2. Select "Using Locale"
3. Change the data type in the dialogue box to "Date Time"
4. Select any of the following that may eventually work for you. (English United States/English New Zealand/English United Kingdom.

Note: If the first attempt of the English..... doesn't work out, use the Settings Icon beside the step for this query to change to another English...

If this works for you, kindly mark it as a solution to allow it benefit other users.