Converting DATE to ISO8601
Converting DATE to ISO8601
zavala
Posts: 2Questions: 1Answers: 0
I uploaded an excel file but the date is displaying as a number.
42260
42261
42263
42285
ie. 42260 should be 09/13/2015
Is there a Javacript call or filter to correct this? Many thanks!
This discussion has been closed.
Answers
Internally, Microsoft Excel stores dates as the number of days that have passed since the epoch. For example, November 1, 2005 is stored as 38657. I need a method to convert an Excel serial date to a proper DateTime object. Thanks again.