Powerhouse123
IS-IT--Management
Hello,
I have a form whereby I want to return a value in the "Valid" field (see below) of "Yes or "Overdue" based on a calculated field and against today's date.
e.g.
Issue Date: 01/01/2005
Expiry Date: (code in control source =DateSerial(Year([Issue Date])+3,Month([Issue Date]),Day([Issue Date]))
field value = 01/01/2008
Valid: I have tried the folowing formula in the control source ...=IF([Expiry Date]=Date(),"Yes","Over Due") This idea works in Excel but I cannot work it out in Access.
So summary of problem in Valid field control source...I want it to say "Overdue" if the expiry date is equal to or greater than today's date.
Many thanks in advance.
Kindest Regards,
I have a form whereby I want to return a value in the "Valid" field (see below) of "Yes or "Overdue" based on a calculated field and against today's date.
e.g.
Issue Date: 01/01/2005
Expiry Date: (code in control source =DateSerial(Year([Issue Date])+3,Month([Issue Date]),Day([Issue Date]))
field value = 01/01/2008
Valid: I have tried the folowing formula in the control source ...=IF([Expiry Date]=Date(),"Yes","Over Due") This idea works in Excel but I cannot work it out in Access.
So summary of problem in Valid field control source...I want it to say "Overdue" if the expiry date is equal to or greater than today's date.
Many thanks in advance.
Kindest Regards,