I just changed the field type to a text one and it gave me this answer:1978. I always have both dates in the table: 2004-06-06 and 2004-06-08....

Patrica Molard

No, keep the field type as DATE. You never want to express dates as text. Without seeing your database, it's difficult to determine anything further... any other ideas out there?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The BD for this test is really simple:
 - 1 table: Placettes with 1 field: DATE_INV (format:Date, 2004-06-06 short format, no mask, no default value,)
 - 1 form: Form1 to fill this table
I already have values in this tables.

I wrote this code at the OPEN EVENT of the form1:

Private Sub Form_Open(Cancel As Integer)
Me.DATE_INV.DefaultValue = Nz(DMax("[DATE_INV]", _
   "Placettes", "[DATE_INV] <= #" & Date & "#"), Date)
End Sub

The result is a new date for each new record but it's 1905-05-31!!!
I really want to use this function and in VB it seems easier than what I already did with macro. BUT it has to work...
Thanks

Patrica Molard

Your code seems fine... here's an off-the-wall question. When was the last time you reset your computer clock?!

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

What do you mean by this ? The windows one, at the right bottom cormer: this one is ok.
Do I have to do something else to reset it ???

Patrica Molard

Try these two tests:

1) If you hold your mouse over the time on the bottom right, today's date appears in a pop-up box. Is that showing the correct date?

2) Go to your dB and open any module. Click VIEW > IMMEDIATE WINDOW. In there, type this:

? Date()

and press ENTER. What does THAT date say?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

It says the right one: 2004-04-22

Patrica Molard

Maybe a new idea: I never create new records. I always navigate through all the records of Placettes'table. The user is not even allowed to create a new one.

Patrica Molard