Read data from excel (date column set as custom data type) ---- in logic apps and convert to json

Question

Dear Gurus,

I have a excel file and it is currently getting converted to JSON in logic Apps.
Problem is the date field in the excel is set to custom data type
When converted to json the date reads as a number ex: 43139

Is there a way to handle this scenario.

Thanks in advance.

Answer 1

This is because that's how dates work in excel. Dates are stored as sequential serial numbers representing the number of days from January 1, 1900.

You can read more about this in the DATEVALUE Function docs.