Hi everybody!
can anybody tell me if it is possible to use the FORMAT function to make a date read EG: 9/11/00 rather than 11/9/00 ?
Thanks in advance for any advice!!
Printable View
Hi everybody!
can anybody tell me if it is possible to use the FORMAT function to make a date read EG: 9/11/00 rather than 11/9/00 ?
Thanks in advance for any advice!!
myDate = Format(Date,"dd/mm/yy")
MsgBox Format(Now, "d/m/yyyy")
or
MsgBox Format(Now, "m/d/yyyy")
Format$(Now, "EG: dd/mm/yy")