Dates & SQL

[smokin_joe]

In my CF form I have created a date object using #DateFormat(Now(),"MM/DD/YY")#
which displays the date as: 07/29/05.

When the date is inserted into a Date/Time Field in a SQL table and I view
the resulting entry in the table looks like: 7/29/2005.

When I query and return the data field (#FIELD#) from the DB it displays as:
2005-07-29 00:00:00.0

All I want to do is to display the date as: 07/29/05
Can I format the output... or is there something else that I should be doing
to the input of the date...?

Thanks !

[rmorgan]

You will need to reformat the output #DateFormat(myvariable, "mm/dd/yyyy")#