ACCESS: Default Value for a Table Feild

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
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?
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
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

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,628
Office Version
2013
Platform
Windows
Date()+90 is ninety days from now, so it should work.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,691
Messages
5,445,982
Members
405,373
Latest member
Marlene Mayo

This Week's Hot Topics

Top