Skip to main content

Show expiry day

  • July 28, 2019
  • 2 replies
  • 24 views
T

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

This topic has been closed for replies.

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

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'.

    T
    • tamoor_ishaq
    • Author
    • New Participant
    • July 29, 2019

    thanks
    its working good.

    Terms & ConditionsAccessibility statement