[b]Formatting a field from Date to Text using a query[/b] 1

[belstoy]

I am trying to take a date format and convert it into text using a query. I have an automated process which sends an excel file out when done. The date format in the excel file is appearing as "00-Jan-00".

Any thoughts?
Belstoy

 

[Melagan]

Date_String: CStr([Your_Date])

SQL:

SELECT CStr(t.[Your_Date]) as Date_String
FROM Your_Table as t;

Maybe that is what you're looking for?


~Melagan
______
"It's never too late to become what you might have been.

 

[belstoy]

Thanks, exactly what I needed!!!