topic Re: If Expression Using a Date Field and Today in App Development

If Expression Using a Date Field and Today

EvanBarrick — Mon, 28 Jan 2019 20:52:58 GMT

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?

Re: If Expression Using a Date Field and Today

dplr-rn — Mon, 28 Jan 2019 21:11:03 GMT

Suggest to Check format of TestDate field

Re: If Expression Using a Date Field and Today

EvanBarrick — Mon, 28 Jan 2019 21:19:51 GMT

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

Re: If Expression Using a Date Field and Today

jonathandienst — Tue, 29 Jan 2019 06:12:28 GMT

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())"}>} ....)