Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Amir Khan 1287 posts 2744 karma points
    Nov 04, 2015 @ 15:30
    Amir Khan
    0

    RSS Datetime formatting

    Hi,

    I'm important an RSS feed with the date time field formatted as such: Wed, 8 Jul 2015 15:18:25 EST

    Shouldn't the following date format match this? ddd, d MMM yyy hh:mm:ss EST

    I keep getting an error when important saying that the field does not contain a valid datetime value.

    Thanks!

    Amir

    Copy Link
  • gary 385 posts 916 karma points
    Nov 04, 2015 @ 15:42
    gary
    0

    Hi,

    Only 3 y's or is that a typo?

    G

    Copy Link
  • Amir Khan 1287 posts 2744 karma points
    Nov 04, 2015 @ 15:56
    Amir Khan
    0

    Good catch, typo. Same result when corrected though...

    Copy Link
  • gary 385 posts 916 karma points
    Nov 04, 2015 @ 16:10
    gary
    0

    RFC1123 pattern date.

    ddd, dd MMM yyyy HH:mm:ss 'GMT'

    For some reason, this one takes capital H

    Regards

    G

    http://www.csharp-examples.net/string-format-datetime/

    Copy Link
  • Amir Khan 1287 posts 2744 karma points
    Nov 04, 2015 @ 17:57
    Amir Khan
    0

    Still the same error. I'm wondering if it is something with CMSImport and converting datetime.

    Copy Link
  • gary 385 posts 916 karma points
    Nov 04, 2015 @ 18:55
    gary
    0

    Found this

    http://www.richardsoeteman.net/CategoryView,category,CMSImport.aspx

    It's old but maybe can help, entry about one-third of the way down the page on correcting date time errors in CMS Import.

    G

    Copy Link
  • Amir Khan 1287 posts 2744 karma points
    Nov 04, 2015 @ 19:24
    Amir Khan
    0

    So close, here's the correct format, the leading 0 in front of the numerical date is what was throwing everything off.

    ddd, d MMM yyyy HH:mm:ss EST

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft