dssingh17-819020 (2/3/2010)
Use =FormatDateTime(Data Field Name,2) or =Format(Data Field Name,"mm/DD/yyyy").
No, impossible, cause lowercase 'mm' will give you minutes in stead of months
its just the mm that would have to be in uppercase and the dd have to be in lowercase
=format(datetimefield.value,"MM/dd/yyyy") = 11/20/2010
or in european format
=format(datetimefield.value,"dd/MM/yyyy") = 20/11/2010
wkr,
Eddy