Date$ format question

[rockinron]

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

[hendramin]

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

[hspc]

also use FormatDateTime function to make a shrotdate,longdate,shorttime,longtime,general format of Date.

[rockinron]

ok. thanks.

i thought the Date$ may be unchanged by the regonal settings but i was not sure.


thanks again!.


Ron