Correct Date format

0
I’m working with an Excel file import that contains a date column, and I want to ensure that users only enter dates in the “dd-MM-yyyy” format. So, first i will import the excel file. If a user enters a date in another format (e.g., “MM-dd-yyyy” or dd/MM/yyyy), I want to trigger a validation error.  How to achive this in a decision?  Thanks everyone...
asked
1 answers
0

The excel internal format of a date and the presentation format are two separated things. Unless the excel date are strings, you don't need to validate the dates.

The other option is to import the dates into strings and do the validation afterwards.

answered