G
Guest
Another one ...
I have three date fields in a table and I want to return an
Approved/Unapproved in another field within the table based on these dates.
I'm not really sure how to do this.
If I were to write out what I am trying to do, it would look like this...
If today's date < 60 days of DATE1, and < 365 days of DATE2 and DATE3, then
put APPROVED in the approval field
Else put NOT APPROVED in the approval field.
Could someone help me with the syntax for this?
Also, where do I put this syntax (ie in the approval field of table?).
Thanks in advance
Paul
I have three date fields in a table and I want to return an
Approved/Unapproved in another field within the table based on these dates.
I'm not really sure how to do this.
If I were to write out what I am trying to do, it would look like this...
If today's date < 60 days of DATE1, and < 365 days of DATE2 and DATE3, then
put APPROVED in the approval field
Else put NOT APPROVED in the approval field.
Could someone help me with the syntax for this?
Also, where do I put this syntax (ie in the approval field of table?).
Thanks in advance
Paul