Guys,
I have a field that calculates the expiry date once I entered the duration starting from the entry date as so:
Me.expirydate = date + duration
It's fine until I want to add 14 days to the duration if the expiry date is today. I tried as follows:
If me.expirydate=today then me.duration = [duration] + 14
Firts time it worked if I refreshed it. Then nothing happen.
Help & thanks
I have a field that calculates the expiry date once I entered the duration starting from the entry date as so:
Me.expirydate = date + duration
It's fine until I want to add 14 days to the duration if the expiry date is today. I tried as follows:
If me.expirydate=today then me.duration = [duration] + 14
Firts time it worked if I refreshed it. Then nothing happen.
Help & thanks