Setting the Default Date Format

By default the report wizard's date format is based on the sytems localization.
If you wanted to change your date field's default output format, you can do so by use of the DefaultDateFormat property.
This property accepts any valid date format string (MM/DD/YYYY or DD/MM/YY etc. see below) and formats any date fields that do not have any data formats associated with them.

<%
'sample usage
objWiz.DefaultDateFormat = "DD/MM/YY"
%>

Some common date formats are show in the table below, given a sample date of 1993-01-27 07:18.297 (Wednesday, January 27th 1993) and other arbitrary values.

Format Output
m/d/yy 1/27/93
dddd, mmmm dd, yyyy Wednesday, January 27, 1993
d-mmm 27-Jan
mmmm-yy January-93
hh:mm AM/PM 07:18 AM
h:mm:ss a/p 7:18:00 a
d-mmmm h:mm 27-January 7:18
d-mmmm-yy 27-January-93
d mmmm 27 January
mmmm yy January 93
hh:mm AM/PM 08:50 PM
h:mm:ss a/p 8:50:35 p
h:mm 20:50
h:mm:ss 20:50:35
m/d/yy h:mm 1/27/93 20:50


If you need us to include any default data type format, send your request to support@aspwebsolution.com
...