Forum Discussion

LB's avatar
LB
Qrew Cadet
2 months ago

Clearing a formula date field

I'm trying to find a solution to clearing 2 formula date fields based on a selection in another drop down field.  I've tried to set up a form rule for this but it appears the formula date fields are...
Forms
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Try this var number NumDays =Case([ Followup Type],

"Standard", 90,

"Extended", 180);

var Result = [Date of Rounds/Consult]+Days($NumDays);

IF([case rounds type] <>  "initial rounds", $Result)

 

 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

... or were you saying to just add zero days of the case rounds type was initial rounds.