ColdFusion/Dreamweaver Date Formats

I'm trying to create a form in Dreamweaver, using Cold Fusion.

Under Application -> Bindings, in a RecordSet, I want to have a date, with the
format MM/DD/YYYY. However, none of the formats listed are in that format, the
closest I can get is DD-MM-YYYY.

I tried following the instructions in this
http://livedocs.macromedia.com/dream...impl/common/ht
ml/wwhelp.htm?context=Using_Dreamweaver&file=37_dis15 .htm from the Dreamweaver
LiveDocs, but when trying to Edit Format List, and clicking the plus button, it
takes me to a Macromedia (LiveExchange) website. When trying to edit any of the
date formats to change them around, it says that the parameters are not
editable.

Anybody have ideas? Thanks very much in advance.

Just use #LSDateFormat(QueryName.dbColumn,'MM DD, YYYY')#

--
Bill Horvath
Free Tutorials for Studio MX
http://www.communitymx.com/free.cfm
Free 10 Day Trial
http://www.communitymx.com/joincmx.cfm

"mgmt_helpdesk" <webforumsuser (AT) macromedia (DOT) com> wrote

I'm trying to create a form in Dreamweaver, using Cold Fusion.

Under Application -> Bindings, in a RecordSet, I want to have a date,
with the
format MM/DD/YYYY. However, none of the formats listed are in that format,
the
closest I can get is DD-MM-YYYY.

I tried following the instructions in this

http://livedocs.macromedia.com/dream...impl/common/ht
ml/wwhelp.htm?context=Using_Dreamweaver&file=37_dis15 .htm from the
Dreamweaver
LiveDocs, but when trying to Edit Format List, and clicking the plus
button, it
takes me to a Macromedia (LiveExchange) website. When trying to edit any
of the
date formats to change them around, it says that the parameters are not
editable.

Anybody have ideas? Thanks very much in advance.

Bill Horvath .:CMX:. wrote:

Just use #LSDateFormat(QueryName.dbColumn,'MM DD, YYYY')#

Don't you mean:
#LSDateFormat(QueryName.dbColumn,'MM/DD/YYYY')#

Say you have the adte Jan 20, 2005 would you want it formatted as
01/20/2005? If so, use the above mentioned code. If, however, you wanted
it formatted as 1/20/2005 (no leading 0 on the month), you would use:
#LSDateFormat(QueryName.dbColumn,'M/DD/YYYY')#

--
Bryan Ashcraft (remove brain to reply)
Macromedia Certified Dreamweaver Developer
Paragon Visuals :: http://www.paragonvisuals.com
TMM Volunteer (DW) :: http://www.macromedia.com/go/team/
~~~~~~~~~~~~~~~~~~~~~~~~
Got Questions? Get Answers
DWFAQ :: http://www.dwfaq.com
PVII :: http://www.projectseven.com/go/
--