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.