If Expression Using a Date Field and Today

[EvanBarrick]

I am attempting to write an If Expression using a Date Field and the Today Function.

I currently have:

=IF(TestDate <= Today(), Sum(Cost), '-'))

However, I can only get the else portion of this IF statement to display. Where am I making a mistake in this expression?

[dplr-rn]

Suggest to Check format of TestDate field

[EvanBarrick]

I believe there are in the same format, however how would I format them to be the same in the event they weren't

[jonathandienst]

If TestDate is a field, and there is more than one possible value in the context of this calculation, then TestDate will evaluate to null, so the expression will be false. Perhaps you need:

Sum(If(TestDate <= Today(), ...))

or

Sum({<TestDate = {"<=$(=Today())"}>} ....)