Excel serial dates conversion in GP

Questions about GP commands and how to do things

Moderator: MSandro

Post Reply
manyone
Posts: 23
Joined: Nov 5th, '17, 07:56

Excel serial dates conversion in GP

Post by manyone » Jul 17th, '19, 06:30

i'm attaching functions for converting Excel serial dates to YMD dates and back. Excel serial dates represents the number of days since 12/31/1899 . Excel has a bug - it treats 1900-2-29 as a leap date when in fact it's invalid, since 1900 is not a leap year. These 2 functions replicate the same behavior, for consistency. Actually, i translated the code that can be found in this article. you can read all about it here:
https://www.codeproject.com/Articles/27 ... Vice-Versa
serial dates.JPG
serial_dates.gpp
(7.17 KiB) Downloaded 26 times

Post Reply