98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Automatic date formula
Automatic date formula
Resolved · High Priority · Version 2003
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
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Deleting duplicate records from a tableYou cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table. |
