Recurring monthly due date

[Cheez]

looking for some help with a recurring date



I have a form with a field call txtStartupDate bound to a table. i have an unbound txtbox with this code in it's row source. =DateAdd("m", 1, [CurrentDate]) but having trouble figuring out how get that to change after that. example 09/19/21 is startup date, DateAdd will return 10/19/21. how would you this going month after mouth.

[CJ_London]

Not really enough info provided - what do you do with the form? do you want to create these as records etc, depends how far into the future you want to go. But lets say it is 12 months.

so you could create a table with a single field and populate it with 1 to 12 (call table tblMonths with a field called mthNum)

then use a cartesian query

SELECT dateadd("m",mthNum,CurrentDate) as dueDate
FROM myTable, tblMonths

[Cheez]

Basically for look's as a reminder to me when my due date is. My credit card online account has this feature. The only value stored in a table is the first startup date. I thought this could calculated field on the fly. Am I going about this the wrong way? would it be better to store this in a table?

[moke123]

DateAdd(interval, number, date)

Use dateDiff() as the argument for the Number in DateAdd()

something like:
=DateAdd("m",DateDiff("m","Your starting date",Date()),"Your starting date")

If its always going to be the same day each month you could use dateserial()

DateSerial(year, month, day)

= dateSerial(year(date()),Month(Date()),day("Your starting date"))

[CJ_London]

and if you want the next due date rather than the one this month use i.e. startupdate is the 10th and today is the 20th September - the next duedate is 10th October


=DateAdd("m",DateDiff("m",Startupdate",Date())-(day(StartupDate)<day(date()),StartupDate)