  Scholar

## Calculated Value If date is less than 12/31/2017

Hey Everyone,

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.

I've tried:

If(TransDate<12/31/2017,Miles*.535,Miles*.545)

If(lessThanOrEqual(TransDate,12/31/2017),Miles*.535,Miles*.545)

Thanks for the help!

Kassie

Update:

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?

Thanks again

Kassie

2 Replies Collaborator

## Re: Calculated Value If date is less than 12/31/2017

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

## Re: Calculated Value If date is less than 12/31/2017

Again, Thanks for your help Marian. 