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 1289 posts 2746 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

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

    Hi,

    Only 3 y's or is that a typo?

    G

  • Amir Khan 1289 posts 2746 karma points
    Nov 04, 2015 @ 15:56
    Amir Khan
    0

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

  • 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/

  • Amir Khan 1289 posts 2746 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.

  • 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

  • Amir Khan 1289 posts 2746 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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies