Age Calculation

[upaliwije]

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

set Vagedate=03/31/2015;

claim:

LOAD YEAR,

    MONTH,

        PRODUCT AS PRD_CODE,

   // date(REPO_DATE,'DD-MMM-YY')AS REPO_DATE,

    //date(LOSS_DATE,'DD-MMM-YY')AS LOSS_DATE,

   FLOOR(REPO_DATE)AS REPO_DATE,

FLOOR(LOSS_DATE)AS LOSS_DATE,

  Vagedate-FLOOR(REPO_DATE)as age,

I have written above script for my QV document with Age as a field (highlighted in red) But it is not working. Pls help me  to correct the error

[simsondevadoss]

$(Vagedate)-FLOOR(REPO_DATE)

[#3 · Accepted solution]

set Vagedate=Date(Makedate(2015,,03,31),'M/D/YYYY');

claim:

LOAD YEAR,

    MONTH,

        PRODUCT AS PRD_CODE,

   // date(REPO_DATE,'DD-MMM-YY')AS REPO_DATE,

    //date(LOSS_DATE,'DD-MMM-YY')AS LOSS_DATE,

   FLOOR(REPO_DATE)AS REPO_DATE,

FLOOR(LOSS_DATE)AS LOSS_DATE,

  $(Vagedate)-FLOOR(REPO_DATE)as age,

[Anonymous]

hi

interval(Today() - date([REPO_DATE]),'d')

you can use your column in place of today.

Thanks

BKC

[upaliwije]

Thanks all