AdobeStock_455007340

Processing POP Dates

Dates returned by (in the query.date column) cannot be used with ColdFusion date functions as is, they need to be converted into valid date time objects. To do this, use the ParseDateTime() function, and set the second (optional) parameter to “POP”. (Applies to: ColdFusion 3 or later)

One response to “Processing POP Dates”

  1. Amir Far Avatar
    Amir Far

    WHEN:
    myCfpopQuery.date is "26 Dec 2005 19:23:12 -0000"
    AND I TRY:
    ParseDateTime( myCfpopQuery.date, "pop")
    I GET THIS ERROR:
    "26 Dec 2005 19:23:12 -0000" is an invalid date or time string.
    That’s the date of an email I received from plaxo.com
    AS you see it is missing the date of the week. If I manualy add "Mon," at the begining, it will be ok.
    What do you think is the best way to deal with these kind of emails?

Leave a Reply