Formating a date

[Mahatmt]

I want to show a date in YYYYMMDD format. The date is stored in the Short format as mm/dd/yyyy. Would I format the date in the Query SQL select statement or in the Control Source parameter for the report field?

What is the correct syntax for the reformat?

Thanks.

Mahatmt

 

[ajdesalvo]

Either way would work:

Format([YourDateField], "yyyymmdd&quot would work in the query itself, or as the control source of the text box control in the report.

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[67peshawar294]

Mahatmt,
In the "format" property of the report field;
yyyymmdd
jim

 

[Mahatmt]

Anthony:

Thanks. I had left off the () in the statement. Must have looked at the for an hour or more and just didn't notice.

mahatmt