Posted by Grant Foraker on October 27, 2011 at 14:45:44:
Date2Num("MMDDYYYY",0)and Date2Num("MM/DD/YYYY",0) both work fine. I don't have to strip out the delimiters. Happy, Happy, Joy, Joy !!!
So, on NUM2DATE(date-serial-number, date-mode) could we have a delimiter as third argument. Like ...
NUM2DATE(date-serial-number, date-mode,"/") giving MM/DD/YYYY
NUM2DATE(date-serial-number, date-mode,"-") giving MM-DD-YYYY
NUM2DATE(date-serial-number, date-mode) giving the old MMDDYYYY
Then I don't have to do so many SUB(DATE$,1,2) + '/' + SUB(DATE$,3,2) + '/' + SUB(DATE$,5,4).
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.