Posted by Jon Sacks (168.100.250.106) on November 08, 2003 at 11:46:59:
In Reply to: Re: NUM2DATE posted by Jim Guerber on November 08, 2003 at 00:50:37:
Here is the "documentation" for Internet basic, so I guess you agree, this is a Hidden feature, How would I have known not to look in the "documentation" but to look in a document about the release of 2004. Do I assume this will only work under 2004? Also, the second question was is there a function to convert the decimal part of day to time?
http://www.signature.net/ib/internetbasic.htm:
The date-mode is a numeric value that determines the format of the resulting date-string.
Date-mode Format of resulting date-string Length of result
==============================================================
0 MMDDYYYY 8 bytes
1 DDMMYYYY 8 bytes
2 YYYYMMDD 8 bytes
3 YYYYDDMM 8 bytes
4 * Day, DD Mon YYYY HH:MM:SS GMT 29 bytes
* Date-mode 4 is the standard format for Internet dates. When used on the current date, this function returns the day of the week (3-character abbreviation), date (formatted as shown, with 3-character abbreviation for the month), and time. The time is expressed as Greenwich Mean Time (GMT) and is based on the current value of the TIME$ system variable.