Hi Everyone
Im really sorry if this has been posted before.
i have a form in my database that contains a financial start date and end date
start date - 07-04-2016
end date - 06-04-2017
is it possible that these dates can automatically change in the new financial year
so for example
when todays date is bigger than 07-04-2017 change the start date to 07-04-2017 and change the end date to 06-04-2018
if so
would this be the logic
if date(now()) > me.startdate then
me.startdate= 07-04 (of the current year)
me.enddate = me.enddate + add 1 year, but keep the day and month the same
end if
for some reason im really struggling with this, im not even sure that the logic is correct to be honest, i have been mulling this over for a while now, i think i have got to the point were i can't see the woods for the trees lol
any ideas how i could do this
many thanks
Steve