Date defaut?

[SteveE]

I have a date entry in a form which keeps returning the date 30/12/1889 even thougth the default is set to =Date() this is probabably a stupid mistake of mine but any help would be welcome.

Thanks

 

[Rich]

Provided you have a valid date field, then check Windows regional settings, Date/Time

 

[SteveE]

Provided you have a valid date field, then check Windows regional settings, Date/Time

Thanks but the settings are ok, and the field acts and records normally most of the time. It seems to happen if a null value (just a return) is entered by the user when adding / editing records.

 

[Rich]

Then use the Before Update Event of the form to check for a valid date input,
ie If Not IsDate(Me.MyField) Then

 

[RV]

Steve,

for more info about this "problem" search the forums here for:

1899

RV

 

[Swannie]

What about using =DateValue(Now()) as the default value - that's what I always use.


Big Swannie

 

[SteveE]

Thanks to everybody whos replied and for all your help, I do have the default set at =Date(). It appears that it when users are browsing or adding a new record that this occurs. (I have a form that has date fields DUEDATE is when the vehicle is expected and is entered by one user the previous day. On the day of arrival the record is updated with ARRTIME and various other specific details by a different user) It seems its at this point where some records (only a few) pickup this wrong date info and default to 30/12/1889