date type

[sagaraperera]

this is a script in my qvd, in this script include DET_RISK_DATE it is saw to number but i want saw a date type already qvd file DET_RISK_DATE mention was date how to correct this issue.

sagara

Directory;

Loading BCOD,

     DET_DEBT_CODE,

     DNAME,

     EXCODE,

     ME_NAME,

     DET_REF_2,

     DET_POLICY_NO,

    DET_RISK_DATE,

     DAYS,       IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS වයස,

     DET_DESCRIP,

     DET_PRODUCT,

     POL_CLA_CODE,

     Leader of Baal

From

ජී: \ qlickviwe \ ගැතිෙයෝ \ DEB_DATA_ASAT_DATE.QVD

(QVD);

[amit_saini]

Hi,

do this:

Date (DET_RISK_DATE,'MM/DD/YYYY') as DET_RISK_DATE

Thanks,

AS

[sagaraperera]

Hello amit thanks your response, but it is not work my qlick vew file and script given below

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

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

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

SET DateFormat='DD-MM-YY';

SET TimestampFormat='DD-MM-YY 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';

Directory;

LOAD BCOD,

     DET_DEBT_CODE,

     DNAME,

     EXCODE,

     ME_NAME,

     DET_REF_2,

     DET_POLICY_NO,

     DET_RISK_DATE,

     DAYS,

     IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS AGE,

     DET_DESCRIP,

     DET_PRODUCT,

     POL_CLA_CODE,

     BAL

FROM

G:\qlickviwe\DEBTORS\DEB_DATA_ASAT_DATE.QVD

(qvd);

[amit_saini]

Hi,

Try this script: (Copy and paste)

Directory;

LOAD BCOD,

     DET_DEBT_CODE,

     DNAME,

     EXCODE,

     ME_NAME,

     DET_REF_2,

     DET_POLICY_NO,

     Date (DET_RISK_DATE,'MM/DD/YYYY') as DET_RISK_DATE,

     DAYS,

     IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS AGE,

     DET_DESCRIP,

     DET_PRODUCT,

     POL_CLA_CODE,

     BAL

FROM

G:\qlickviwe\DEBTORS\DEB_DATA_ASAT_DATE.QVD

(qvd);

Thanks,

AS

[sagaraperera]

thanks dear

it is work properly

sagara

[amit_saini]

Glad to help you, please close the thread by marking correct or helpful answer.

Thanks,

AS