How can I change the format of date to dd/mm/yy.
When I hover over the Date function in debug it presents mm/dd/yy
By default it seems to be mm/dd/yy and it is causing havoc with my validation procedures!
Printable View
How can I change the format of date to dd/mm/yy.
When I hover over the Date function in debug it presents mm/dd/yy
By default it seems to be mm/dd/yy and it is causing havoc with my validation procedures!
If your days and months are swapped around then its probably your regional settings in control panel causing the problems.
If you are in the UK and you have the date region set to United States it will swap all your pcs dates round to mm/dd/yy
That has solved it
Thanks Blobby!