How to validate US dates stored as YYYY-MM-DD

James Sidebotham
edited December 2023 in General

I have several fields that have dates stored in the format above. If I run the built in function "Is Date", the dates all fail. Is there a date system setting I need to change, or create my own function?

What date format does the "Is Date" function require?

Best Answer

  • James Sidebotham
    Answer ✓

    Thanks Josh. The column is brought across as an alphanumeric. So looks like i should either import as date or do some conversion before validation.

Answers