Date variables are displayed accordingly to your systems shortdate format.
Times are displayed according to your systems time format, either 12 or 24 hour format.
These settings can be changed from your control panel.
Switching this to "English (UK)".
Notice that none of the available formats have an asterisk
Therefore this will be the date format in every region regardless of regional settings.
If you want to see different date formats for different regions, you should access the "Region and Language" dialog box from the control panel.
Customise your default date format
If you have your setting set to "English (UK)" then the default date format is "dd/mm/yyyy"
If you would rather not see the extra zeros (eg 1/7/2010 instead of 01/07/2010) this can be changes from the control panel.
Display a time using the short time format specified in your computer's regional settings.
Dates that contain times are displayed in Long Time format. Dates outside 1930-2029 will always be formatted with four-digits for there year component, regardless of the Short Date format
Medium Date - Uses a format applicable to the current system locale
Medium Time - Uses the 12-hour format
The calendar exposes the calendar system that is currently being used.
There are two types of calendar. The default is vbCalGreg. The other is vbCalHijri.
The Date property expects a date passed to it
Any time information is ignored
The Date$ property returns and assigns dates from strings
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext