Date Parsing of String "Date: Fri, 11 Dec 2020 20:59:07 GMT"

Comments

2 comments

  • Konsta Danyliuk

    Hello Anson.
    It seems you need to change the Month pattern from MM to MMM.

    I'm able to parse the date from your example using the pattern "EEE, dd MMM yyyy HH:mm:ss ZZZ".

    ASDATE("Fri, 11 Dec 2020 20:59:07 GMT";"EEE, dd MMM yyyy HH:mm:ss ZZZ")

    I hope this helps.

    0
    Comment actions Permalink
  • Anson Chan

    Thank you very much Konsta!

    0
    Comment actions Permalink

Please sign in to leave a comment.