does this work with dates as well?

[Xx Allure xX]

(refers to this post earlier: http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=137028#post137028 )


I'm also in a fix such as his. Does that work with dates as well? I have a field to put in completed dates for safety training and was looking for help finding a function to generate a due date for the next time they need to train for that field. I know I need to make another text box but some of them will not be generating the same interger for the dates. Some will be a year from the date completed and some will be 2 years or even just 6 months. How do I make a function like that and where do I put that function in?

I'm not that well familiar with the Visual Basics part so I would also need step by step on how to get there adn where to put this information.

Please please help me.... I need this before tomorrow hopefully by tonight .. THANK YOU!!

 

[neileg]

Why embed these due dates in your data? Why not run a query that tests to see if the due date is about to come up on a regular basis?

Alternatively, if you're not hot on VBA, why not run an update query that adds a fixed number of days to your completed date to generate an value for the next due date.

 

[Xx Allure xX]

how do I make it so the date I input and teh generated date are both showing? If this is possible could you please help me?!?! PLEASE?!?!?!?!

 

[Rich]

I think your looking for the DateAdd function, look at the examples in the Help file

 

[neileg]

Say you have a table with two fields, PersonID and DateIn. If you want to generate a date that is 6 months after DateIn, create a query that has three columns.
First two are simply the fields from the table, PersonID and DateIn.

The third should have in the field name RecallDate:[DateIn]+183

This adds 183 days to DateIn (ie six months). This will give you a recall date six months on.

If you put in the criteria rows for RecallDate
Between Now() and Now()+7
this will return all records where the recall date is in the next week.

You can use DateAdd instead of just adding a whole number of days, if you prefer, but you may find that simple arithmetic is easier to understand until you get this cracked.