-
how can i SET the date into long date format (regional settings)?
i want that once my form is loaded, it will automatically SET the date in the regional settings into long date format.
-
Hell miletjs,
Use the format function:
MsgBox FormatDateTime(dteDate, vbGeneralDate)
MsgBox FormatDateTime(dteDate, vbLongDate)
MsgBox FormatDateTime(dteDate, vbShortDate)
MsgBox FormatDateTime(dteDate, vbLongTime)
MsgBox FormatDateTime(dteDate, vbShortTime)
MsgBox Format$(dteDate, "ddd, mmm d, yyyy")
MsgBox Format$(dteDate, "mmm d, H:MM am/pm")
Nice regards,
Michelle.
