Please consider adding tokens to the mask in the FormatDate() function, i.e.:
%m = month in 1 or 2 digits, as necessary
%d = day in 1 or 2 digits, as necessary
%h = hour in 1 or 2 digits, as necessary
Right now, if I want a date formatted like "1/1/2004" instead of "01/01/2004", I have to use something like
Code: Select all
Str(Month(Date())) + "/" + Str(Day(Date())) + "/" + Str(Year(Date()))
Code: Select all
FormatDate("%m/%d/%yyyy", Date())

I guess single digits for minutes and seconds could also be handy, but I use them as two digits most of the time.
Thanks,
Eric