date

[upaliwije]

Hi Friends

DUAL( DATE(POL_PERIOD_FROM,'MMM-YY') &' - '& DATE(POL_PERIOD_TO,'MMM-YY'),POL_PERIOD_FROM)  AS POLICY_PERIOD

pls help me to write systax to extarct Date from (POL_PERIOD_FROM) from the above syntax

[qlikviewwizard]

Hi,

Can you attach the sample file with the data?

[upaliwije]

The the QV sample cannot be attached. I want to know where date can be separately identified from my systanx

[qlikviewwizard]

Hi,

Can you give some sample data of POL_PERIOD_FROM,POL_PERIOD_TO?

Are you using default SET configurations?

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';

[Anonymous]

What does your POL_PERIOD_FROM field consists of ?

[sunny_talwar]

Not sure what you mean? You already have POL_PERIOD_FROM which you are using to create POLICY_PERIOD. Are you looking to again extract POL_PERIOD_FROM from POLICY_PERIOD?

[upaliwije]

Yes  I want to extract POL_PERIOD_FROM  and link same to master calender

[sunny_talwar · Accepted solution]

May be this:

Date(Num(POLICY_PERIOD) as POL_PERIOD_FROM