1 Reply Latest reply: Dec 4, 2012 2:51 PM by Wojciech Parzyszek RSS

    Ageing Analysis Report issues

      Hi,

       

      i am trying to do ageing analysis based on the dates available in the field.

       

      Ex:

       

      IF

       

      (Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 0,'Today',
      IF(Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY') = 1,'1day',) )As OpenTime

       

      I have modified the format of data and when i use this in expression in the report it returns me the number but when i upload it in main edit script page and reload the script, i dont get any values in newly created 'OpenTime' column.

       

      Please guide.

        • Re: Ageing Analysis Report issues

          expression

           

          Today()- Date(MakeDate(Year(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY')),Month(Date#(Date([Submit Date],'M/DD/YYYY'), 'MM/DD/YYYY'))), 'MM/DD/YYYY')

           

          gives 0 if today()=first day of month and [Submit Date] = today()

           

          gives 1 if today()=second day of month and [Submit Date] = yesterday

           

           

          what i mean is your condition probably never is true