Date format problem - between access and coldfusion 1

[buddyholly]

I am using access as the database with coldfusion/dreamweaver MX. One of the fields in the access database is for dates. I have access stamping the date automatically whenever a new record is created.

I have chosen
default value Date()
and
format Short Date

However Access seems to insist on adding on the time to the date when a cfm page is presented. So, I get the right date format plus an unwanted time stamp.

many thanks for any pointer on sorting this out

james

 

[myatia]

Access automatically adds a time stamp to any date you put in it. To not view it in your output, use the DateFormat function. For example, #DateFormat(AccessDate, "M/D/YY&quot# will give you a date of the form "3/17/03". For more info, see

http://livedocs.macromedia.com/cf50docs/CFML_Reference/Functions58.jsp#1103264

 

[buddyholly]

Many thanks !!!

thats fixed it

james