Date to String

[docmiller]

I want to pass in a date to a query that is run against a table where the date field is actually a text field with the implied date in the yyyymmdd format. How can I create a string for a Date()?

 

[SkipVought]

Hi,

...
Where [MyStrDate] = Format(Date(), "yyyymmdd")

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}