ACCESS: Default Value for a Table Feild

[gheyman]

I have a field that is a Date/Time. It is a required field so I want to put a default in it. I want to add an expression that will give me 90 days from the date the record was entered.

I don't think it is =NOW()+90 because I think that includes time. Is it Date()+90?

 

[welshgasman]

Why not just try it?

 

[gheyman]

I was away from my Access Program when I created the question. I had to leave for a Flight. Since then I did try it and it did not work.

 

[xenou]

Date()+90 is ninety days from now, so it should work.

 

[welshgasman]

Indeed it does, so no idea what the o/p was doing