Converting string to Date

Forum|Forum|18 years ago
April 21, 2008
2 replies
709 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")#

Advanced techniques

This topic has been closed for replies.

J

JR__Bob__Dobbs-qSBHQ2

Inspiring

Try removing the quotes from around query.orderdate.

-

-__cfSearching__-

Inspiring

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

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded