Converting string to Date

[Newsgroup_User]

Can coldfusion convert the following date string query variable i have
20080418 to a formatted date.

eg; 15-Apr-2008


Or does my string have to be something like 20008/04/18 or 2008-04-18


This dosent work below, I dont have the quotes in the right places I think.

Thanks
B

#dateformat("query.orderdate", "d-mmm-yyyy")#

[Dan_Bracuk]

The best answer is to store dates as dates instead of strings.

But, if you must use strings, look at these cold fusion functions, left, mid, right, and createdate

[JR__Bob__Dobbs-qSBHQ2]

Try removing the quotes from around query.orderdate.

[-__cfSearching__-]

bj wrote:

quote:

---

Can coldfusion convert the following date string query variable i have 20080418 to a formatted date.
eg; 15-Apr-2008

---

No. DateFormat expects a "date" object and returns a string. Since 20080418 is not a date object ColdFusion treats it as a numeric representation of a date. Not as 2008-04-18 (ie April 18, 2008).

AFAIK, your options are those Dan Bracuk suggested. Either store the values as "dates" or use functions to convert your string into a "date" object first. Then use DateFormat.