CSV format for Date

[anissw]

Hi- Does anyone know how to have a csv format with the fileds of date to display only my date field instead of datetime field? I tried CDATE and when I review my output, the format is still datetime. This export is from within a query I created.

Thanks-

anissw

 

[Beetle]

Use the DateValue function;

DateValue([YourDateTimeField])

 

[anissw]

Hi Beetle- Thanks for the reply. It appears that I need to export to an Excel file instead of a .csv. I did test the DateValue format and the format comes out as dd-Mon-yy. The month is the 3 character abbreviation. Is there anyway for the date to display mm/dd/yy?

Thanks-

anissw

 

[Beetle]

Format(DateValue([DateField]),"mm/dd/yy")

 

[anissw]

Thanks- That worked pefectly!!