Skip to main content
N
Newsgroup_User
Inspiring
April 21, 2008
Question

Converting string to Date

  • April 21, 2008
  • 2 replies
  • 708 views
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")#


This topic has been closed for replies.

2 replies

J
JR__Bob__Dobbs-qSBHQ2
Inspiring
April 22, 2008
Try removing the quotes from around query.orderdate.
-
-__cfSearching__-
Inspiring
April 22, 2008
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.
D
Dan_Bracuk
Inspiring
April 22, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices