i am working with ODATA API and the date field i am getting is in JSON date format eg: /Date(1562918858000)/

Question

i need to convert that date /Date(1562918858000)/ in normal date format

Answer 1

Hi @kishan ranka ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query.

• To format Dates in Azure data factory, Pipeline expressions you can use: formatDateTime() function.
• To format Dates in Azure data factory, Data flow expressions you can use: toDate() fucntion.

Between, in your case "1562918858000" is not giving any sense of date format. Could you please help me to interpret date format in that?

Hope this helps. Thank you.

-------------------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications