Date/time Data type

When the date is entered into the date/time data type in the format dd/mm/yy, if the data type is passed for example as 04/13/2000 it is changed by the data type to 13/04/2000 (13 is recognised as an invalid month and swapped with the day). In my opinion this should fail to assign to the data type, as in my case the user has genuinely entered the date incorrectly. This seems to apply to different date formats.

If a text box is bound to a date/time field it is impossible to validate for this error. Is there a solution/workaround to this that doesn't involve using an unbound text box or to make the date/time data type fail to accept this value.

Any help much appreciated.

Try using the medium date ie. 13-Apr-00. people are less likely to make a mistake when entering this format.

Chuck

how do you implement a medium date???

i change the field format in access to dd/mm/yyyy
but i cant seem to get that format when i display it in my FLEX grid why????



my whole project is based on the format dd/mm/yyyy and yet i am getting all sorts of problems why??????????????


anyone??

i have been conuslting with 38 post and still klnow one could help can someong please help with this