Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Automatic date formula

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Automatic date formula

Resolved · High Priority · Version 2003

Reply Wed 2 Feb 2011, 17:38Delegate Gregory said...

Gregory has attended:
Access Intermediate course
Access Advanced course

Automatic date formula

Is there a way to enter a formula in a date/time field in a table which automatically enters the current date.

I am trying to have percentage split which gets changed over time. However the current split must always be todays date.

The query is something like this

TradeValue * Split
Where TradeDate > SplitValidFrom && TradeDate <= SplitValidTo

Is there a way for an expression which whenever referenced will give the current date in the SplitValidToField?

If not what is the code to replace null values with todays date in the query.

If any screenshots are required please email to my delegate email address

Many thanks,
Greg

For upcoming training course dates see: Pricing & availability

Reply Thu 3 Feb 2011, 08:33Trainer Simon said...

RE: Automatic date formula

Hi Gregory,

Thank you for your question.

Is the SplitValidToField set up as a Date and Time field in the table?

If so, go to Design View of the table and select the field. Go to the Default Value property for the field and type =Date(). This date function will alwaus default the current date in the field.

I hope this answers your question.

Regards

Simon

Wed 9 Feb 2011: Automatically marked as resolved.

Access articles

· Use Split Form View In Access For Simultaneous Views
· It's so easy to Access the information you need
· How To Change The Data Displayed In A Linked Field In An Access Table
· Use Microsoft Access to manage your work/life balance
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips