Due date comparison in set analysis

arodriguez_nyn — Fri, 29 Jun 2018 07:52:20 GMT

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.

Re: Due date comparison in set analysis

sunny_talwar — Fri, 29 Jun 2018 14:49:57 GMT

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.

topic Re: Due date comparison in set analysis in App Development

Due date comparison in set analysis

Re: Due date comparison in set analysis