change date month to current month

[basilyos]

hello

i have a list of clients each with recharge date

for example i have a recharge date for client 01/05/2019 (april)

i want to renew the subscription so i should have a new date 01/08/2019 (august)

i renew every month with this expression

DateAdd("m",1,[tblPersonalInformation].[Date_of_Recharge])

but i cant use it with my new case

so any help

 

[Dreamweaver]

I would add a table and use that to keep track of subscritions rather than just keep updating the main clients record the advantage of adding the table is you will be able to get a history for clients and other data you could mine from queries.


mick

 

[arnelgp]

01/05/2019 is may.
do you have any special formula on how to get the recharge date.

 

[almahmood]

What is your new case?

 

[Mark_]

2nd to Mick's response.

Normally you have a process or query that adds a new record that has the "recharge" date. This record normally also holds when it is paid, amount owed, amount paid, and any other special information needed.