Date expression

[jduluc12]

Hi,

Suppose if today is 03/23/2017 and i want to build an expression for sum of amount

from 04/23/2016 to 05/23/2016 then how to build it.

what should be the set analysis for it?

sum({<>}Amount).

Thanks,

Jean

[Anonymous]

Try something like this by creating a datenum field

{<numDate = {">= $(=num(Max(AddMonths(Date,-10)))) <=$(=num(Max(AddMonths(Date,-11)))) "}>}

[sunny_talwar · Accepted solution]

May be this

Sum({<DateField = {"$(='>=' & Date(AddYears(AddMonths(Today(), 1), -1)) & '<=' & Date(AddYears(AddMonths(Today(), 2), -1)))"}>}Amount)