I have a list of dates strings entered as dd.mm.yy
These dates are added into an application that doesn't perform the validity of the entry and then exported into the file I am checking.
I need to check the entries to ensure they reflect an actual date, e.g. 32.01.21 will be flagged as invalid.
I thought by replacing the . character with a / character would work but the new value is interpreted as 22nd Jan 2032.
I have tried using DateSerial but this returns 1st Feb 2020.
If anyone can suggest a solution that doesn't required the original entry to be entered with a / instead of a . it would be appreciated.
Thanks
These dates are added into an application that doesn't perform the validity of the entry and then exported into the file I am checking.
I need to check the entries to ensure they reflect an actual date, e.g. 32.01.21 will be flagged as invalid.
I thought by replacing the . character with a / character would work but the new value is interpreted as 22nd Jan 2032.
I have tried using DateSerial but this returns 1st Feb 2020.
If anyone can suggest a solution that doesn't required the original entry to be entered with a / instead of a . it would be appreciated.
Thanks