Problem with Default Value of Date in Form

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

I want to set the default values of begin and end date in a Form, such as
to encompass all possible records. All fields in the Form are unbound.

Format of the date fields are set to medium Date.

Putting in a date in the default value gives absolute wrong dates. (in
medium or regular date form)

For the time being I put in the default Value "now()-10000" for the begin
date and "now()+10000" this gives a date in 1976 and 2031.

It serves the purpose, but feels very amateurish, especially when you
focus on the fields by clicking on it, and it shows hours:minutes:seconds
added to the date.

Any advise will be greatly appreciated
Thank You, Joseph
 
What do you mean that "putting in a date in the default value gives absolute
wrong dates"? What do you get instead of the date?
 
Thanks for the response. It made me try a bit more and most the time I got
errors except for 01/01/1990 which came back as 31-dec-99.

I then used : =DateSerial(2045,12,31 in the default value for the End Date
and the same as: =DateSerial(1990,01,01) for the Begin Date.

That works just fine and now no hours, minutes and seconds are attached to
the date.

Thank You
Joseph
 
Back
Top