15 Replies Latest reply: Jul 27, 2012 5:30 PM by Michelle Malone RSS

    Subtraction of two dates to get aging problem

      I seem to be having a problem with date fields.  I'm trying to set up an AR aging summary and my data is not showing up in the expressions I have set up.

      I have an input field so the user can enter an 'AS of Date'

       

      The variable for that is called vDate.

      In my initial load I have the vDate defaulting to the system date.

       

      LET vDate = (Today());

      I have tried 2 different variations

       

      In my table, I have the following expressions but they don't seem to be working:

      =if(date($(vDate)) - date([Due Date]) <=10,sum([Balance in Trans Currency]))

      =if(num($(vDate)) - num([Due Date])>=11 AND Num($(vDate)) - Num([Due Date])<=30,sum([Balance in Trans Currency]))

       

      Any ideas on what my problem might be????