ASDATE parsing Query with format Jan 21, 2021 @ 20:34:54.000

Comments

1 comment

  • Konsta Danyliuk

    Hello Anson.
    The ASDATE function should recognize the original with the pattern MMM dd, yyyy @ HH:mm:ss.SSS

    ASDATE("Jan 21, 2021 @ 20:34:54.000"; "MMM dd, yyyy @ HH:mm:ss.SSS")

    There are two possible reasons why your approach throws the error:

    • A semicolon instead of a dot as the separator between seconds and milliseconds.
    • Absence of the second space between years and hours. If you simply deleted @ with the REPLACE function, spaces that surrounded it are intact and you should consider them in the pattern for the ASDATE .

    I hope this helps.

    0
    Comment actions Permalink

Please sign in to leave a comment.