Forum Discussion
MarkShnier__You
5 years agoQrew Legend
np
If([Report Posted]= true and Today()>[MSO-Client Due Date], true, false)
but that can also be written with less typing as
[Report Posted] and Today()>[MSO-Client Due Date]
And another one if the report was issued after the contract deadline:
If([Report Posted]= true and Today()<[MSO-Client Due Date], true, false)
and similar it can also be written
[Report Posted] and Today()<[MSO-Client Due Date]
note that for one of them you also should deal with the equals the due date.
[Report Posted] and Today() <= [MSO-Client Due Date]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If([Report Posted]= true and Today()>[MSO-Client Due Date], true, false)
but that can also be written with less typing as
[Report Posted] and Today()>[MSO-Client Due Date]
And another one if the report was issued after the contract deadline:
If([Report Posted]= true and Today()<[MSO-Client Due Date], true, false)
and similar it can also be written
[Report Posted] and Today()<[MSO-Client Due Date]
note that for one of them you also should deal with the equals the due date.
[Report Posted] and Today() <= [MSO-Client Due Date]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------