Forum Discussion
3 Replies
Sort By
- MarkShnier__YouQrew LegendTry this as a formula date field called Inspection Required.
IF([Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- HunterBQrew Cadet
Thank you how would it look if I want it say add 1 year for all options except air monitor if air monitor then 90 days?
------------------------------- MarkShnier__YouQrew Legendnp
IF(
[Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90),
AdjustYear([Serviced/Inspection Date], 1))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------