Date Format 1

[EastIndian]

I have a field in an Access database called BidDate in which dates are entered in the database as a short date (example) 05/30/02. When I recall the field based on a very simple query, the format of the output looks like this 2002-05-30 00:00:00. Is there a way to modify the apperance of that output to simply be MM/DD/YY. Currently, all I am using to recall the info is #BidDate#. Thanks for your help.

 

[Extras]

It is actually quite easy to do this in CF...

<cfoutput#DateFormat(BidDate,&quot;MM/DD/yy&quot#</cfoutput>

changing the number of Ms, Ds and Ys gives you various long and short forms of the dates.

There is soem great documentation on this in CFStudio if you are using that as your developing environment.

 

[Extras]

OOPS! slight syntax error in the post - it should be:
<cfoutput>#DateFormat(BidDate,&quot;MM/DD/yy&quot#</cfoutput>