Help

Show expiry day

Topic Labels: Formulas
884 2
cancel
Showing results for 
Search instead for 
Did you mean: 
tamoor_ishaq
4 - Data Explorer
4 - Data Explorer

i create one table for employee .in that i create one filed passport expiry.i want that one more field should shoe that if expiry date is gone.filed show some message

2 Replies 2

Make a formula field with this formula IF({Expiry Date field}>TODAY(),'Passport is Expired!','Passport is Valid') If you want the field to be blank if the passport is not expired, remove the ,'Passport is Valid'.

tamoor_ishaq
4 - Data Explorer
4 - Data Explorer

thanks
its working good.