Skip to main content
November 7, 2008
Question

cfpop date issues

  • November 7, 2008
  • 2 replies
  • 352 views
Hello all,

I'm writing a small app that will display a user's email on a "dashboard". Everything is working pretty good except the date/time. I've used the ParseDateTime() function, but the time usually comes out completely wrong.

I just sent (1:00 pm CST) myself an email and the date that appears is as follows:

Fri, Nov 07, 2008 - 06:58:05PM when using ParseDateTime [#DateFormat(ParseDateTime(my_sorted_email.date,"pop"),"ddd, mmm dd, yyyy")# ]

Fri, 7 Nov 2008 10:58:05 -0800 (PST) when displayed without parsing. [#my_sorted_email.date#]

Can anyone offer any suggestions?

Thanks,
Robert

This topic has been closed for replies.

2 replies

November 12, 2008
robs67,

That helped, but it still didn't convert to my time zone (CST). After more searching, I came across this:

http://www.petefreitag.com/item/569.cfm

It has solved my case; at least for the time being. I may have to tweak it some if I come across an unusual format.

Thanks for the suggestion.

November 11, 2008
I believe the argument "pop" in ParseDateTime() returns a conversion to GMT. Try substituting that with "standard":

#DateFormat(ParseDateTime(my_sorted_email.date,"standard"),"ddd, mmm dd, yyyy")#