Date Question
On Wed, 9 Sep 2009 21:22:03 -0700, paduanow wrote:
Where do I put the Format command?
I'd use the Format *function* - not command - in whatever query you use to
export the data to the state's formatted file: you can just put
ExpDate: Format([datefield], "yyyymmdd")
in a vacant Field cell in the query, and then export this query.
Don't confuse data STORAGE with data PRESENTATION. They are different tasks!
--
John W. Vinson [MVP]
|