Due date comparison in set analysis

[arodriguez_nyn]

Hi all,

I have an inline table with due dates, such 30 days, 60 days, 90 days, etc., and need to show the records whose date value is within these periods. After looking up some examples in the Community I have tried two possible solutions that are supposed to work:

Version 1: sum({MyDate={">=$(=vDueDate)"}>}MyAmount)

Version 2: sum({MyDate={">=$(=Today() + DueDateDays"}>}MyAmount)

Where DueDateDays are values of the due dates table and vDueDate variable is set as .Today() + DueDateDays.

But none of them work for me.

Any help?

Thanks.

Alberto.

[sunny_talwar]

May be add the missing things

Sum({<MyDate = {">=$(=Date(Today() + DueDateDays))"}>} MyAmount)

This doesn't guarantee that the expression will work... but those things are essentials. Other things might be needed based on your data and exact requirement which isn't very clear.