convert date from number format to date format dd/mm/YYY

Asked Oct 04 '22 at 10:19

Active Oct 04 '22 at 10:32

Viewed 87 times

I have a date value stored as number '44567' that i would like to convert to date format using javascript

var datexx = new Date(44567).toDate("dd/mm/YYYY");
                        console.log('date: ', datexx);

on excel file this value is equal to 06/01/2022

thank you

edited Oct 04 '22 at 10:32

asked Oct 04 '22 at 10:19

OUED

How can `44567` be converted to a date...? – Rory McCrossan Oct 04 '22 at 10:22
it has been converted like so after an upload of data from excel file. On excel it happens when changing date format to number – OUED Oct 04 '22 at 10:25
44567 might be timestamp. – Gabriel Aoki Oct 04 '22 at 10:27
1

After researching it appears Excel interprets 5 digit timestamps as days since 01-01-1900. So to convert your value to a date you just need to add that many days on, which can be done like this: https://stackoverflow.com/a/563442/519413 – Rory McCrossan Oct 04 '22 at 10:45

0 Answers0