Darren
darren at activebilling.com.au
Tue Nov 27 17:08:28 CST 2012
Hi Y'all
I am storing some DateAdd functions in a 2 column table to give users a list
of choices for automatically creating a new "next due date"
Values in the table look like this
DateAddDescription DateAddvalue
-----------------------------------------------------
Every Day DateAdd("d",1,NextDueDate)
Every Week DateAdd("d",7,NextDueDate)
Every Month DateAdd("m",1,NextDueDate)
Every 3 Months DateAdd("m",3,NextDueDate)
Every 6 Months DateAdd("m",6,NextDueDate)
When a user selects one of these items from the combo I'd like the actual
Date Add function selected, to be applied to the actual "next due date" on
the form
Assume the "next due date" is blank in a new record, once a user selects a
value from the combo, say....the 4th one
DateAdd("m",1,NextDueDate)
I'd like the new due date on the form to be "2013-2-28"
Make sense?
Many thanks in advance
Darren