I'm struggling to get this calculated value working. My formula is: If(date<12/31/2017,field*.535,field*.545)
Basically if the date entered is less than a certain date, I would like it to calculate using the first value, and if it's not I would like it to calculate with the second value.
However, my calculation always ends up the same amount no matter if it meets the condition or not.
Thanks for the help!
ok, I thought maybe instead of combining the if and the calculation, I would just make two calculated value fields and add rules to hide or show the calculation. the rule is lessThanOrEqual(Date,12/31/2017).
this isn't working either. Is there something funky I need to know about using date fields for rules?
Solved! Go to Solution.
if you have written dates in a form just like you posted above, then note they are not taken as dates by the rule engine, but rather as math expressions that divide 3 figures. so you compare dates with a value like 0.000192 (12/31/2017).
you should use ConvertToDate() function to make date out of a string, like ConvertToDate("12/31/2017").
note however, ConvertToDate() is buggy in recent forms version(s), and your formulas need not work even that way.