I am working on a contract and need a date to be the current date if {month3} is after the current date. I have tried it every way imaginable. I have 2 scenarios where if {month3} is after the current date it prints {month3}, but if {month3} is prior to the current date it prints the current date and hides part of the text above it. It works on one but not the other. Go easy on me, it's my first post!
IF TOTEXT({Month3},"MMMM dd, yyyy") >= TOTEXT((Currentdate),"MMMM dd, yyyy") THEN TOTEXT((Currentdate),"MMMM dd, yyyy")
ELSE TOTEXT({Month3},"MMMM dd, yyyy")
{Month 3} = 7/30/2020 From contract signing to July 30, 2020 From July 07, 2020 to the start of the official event date
the other one is right {month3} = 5/18/20 Top sentence is hidden and it says: From July 07, 2020 to the start of the official event date
Aucun commentaire:
Enregistrer un commentaire