date
Formating a date as a date string for a locale specified
By Sergey - Posted on December 29th, 2008
The GetDateFormat Windows API function formats a date as a date string for a Locale Identifier specified. The formatting is controlled either by flags specified or on the formatting string, if provided. The function accepts SYSTEMTIME Structure as one of its parameters.
Convert Excel serial number date to VFP date
By Sergey - Posted on January 1st, 2008
Excel stores dates as the number of days since 1900-01-00. The number 1 represents 1900-01-01 and so on. The time part, if present, is represented as decimal portion. There's a bug in implementation of that sequence. It assumes that there was 1900-02-29 but 1900 is not a leap year. As result the code below correctly convert dates starting with 1900-03-01 only.
For more info about Excel dates see How to use dates and times in Excel and Dates And Times In Excel.
Calculating Nth Occurrence for Day Of Week in the Month
By Sergey - Posted on January 1st, 2008
Recent comments
3 weeks 1 day ago
3 weeks 2 days ago
3 weeks 2 days ago
5 weeks 2 days ago
6 weeks 5 days ago
7 weeks 13 hours ago
8 weeks 1 day ago
11 weeks 16 hours ago
12 weeks 7 hours ago
12 weeks 7 hours ago