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

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

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


Sign In or Register to comment.