Discussion Locked

XP ACCESS - dates

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
in a data/time field setup for shortdate with an input mask - if I type 13/05/05 ACCESS returns 05/05/2013- obviously there is no 13th month - I thought that by using the Date/Time function - ACCESS would automatically verify for date accuracy - what do I need to do now, maybe write a validation rule (how/where (table/form etc)change my format, etc. so that an error msg will automatically pop up to notify the user that the date has been input wrong. This error also occurs in 97 and 2000. Any and all help is greatly appreciated by me and forever by my users. Thank you

2 replies

by grungemann

The simplest thing to do is to set the date field format to dd/mm/yy or whatever format you want in the table design.

Another way is to use the isdate function in the form's after update event.

by im_a_beginner

if you have table under the date the format should be shortdate and the validation rule should be date()... so that when you save your information to the table there is a message about the date....

This discussion is closed to new replies.