change date month to current month (1 Viewer)

basilyos · Aug 23, 2019

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

Code:

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

but i cant use it with my new case

so any help

Dreamweaver · Aug 23, 2019

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 · Aug 23, 2019

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

almahmood · Aug 23, 2019

What is your new case?

Mark_ · Aug 23, 2019

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.

change date month to current month (1 Viewer)

basilyos

Registered User.

Dreamweaver

Well-known member

arnelgp

..forever waiting... waiting for jellybean!

almahmood

Registered User.

Mark_

Longboard on the internet

Similar threads

Users who are viewing this thread