does the Date$ ALWAYS give me the date in the same format or can it change if the computer has the date setup different??
i would like it to always show me the date in this format:
MM/DD/YYYY
Printable View
does the Date$ ALWAYS give me the date in the same format or can it change if the computer has the date setup different??
i would like it to always show me the date in this format:
MM/DD/YYYY
Date$ behavior is unchanged by the Calendar property setting (regional option). Date function does. but Date$ return a 10-character string of the form mm-dd-yyyy.
to format the Date to mm/dd/yyyy, use format function
also use FormatDateTime function to make a shrotdate,longdate,shorttime,longtime,general format of Date.
ok. thanks.
i thought the Date$ may be unchanged by the regonal settings but i was not sure.
thanks again!.
Ron