DATE FORMAT

[upaliwije]

Hi Friends

In my data model following fields exists among others

PROV_MONTH       PAID_MONTH

2015-01                  2015-04

2015-02                  2015-06

2015-03                  2015-07

2015-04                  2015-07

2015-05

2015-06

2015-07

IF((NUM(PAID_MONTH)-NUM(PROV_MONTH))>5,'>5 MONTHS',PROV_MONTH)As PROV_MONTH1

I have written above in my load script. and I want output as follows

PROV_MONTH1

>5 MONTHS

2015-05

2015-06

2015-07 

But it does give desired results instead all months are listed. Pls help me

[sunny_talwar]

Altered your data a little bit. Is this what you want?

Script:

Table:

LOAD *,

  If((Check2-Check1) > (5*30), '>5 MONTHS', PROV_MONTH) AS PROV_MONTH1,

  (Check2-Check1) as Difference;

LOAD Date#(PROV_MONTH, 'YYYY-MM') as PROV_MONTH,

  Date#(PAID_MONTH, 'YYYY-MM') as PAID_MONTH,

  Num(Date#(PROV_MONTH, 'YYYY-MM')) as Check1,

  Num(Date#(PAID_MONTH, 'YYYY-MM')) as Check2

Inline [

PROV_MONTH,      PAID_MONTH

2014-12,                  2015-04

2014-02,                  2015-06

2014-09,                  2015-07

2015-04,                  2015-07

2015-05,

2015-06,

2015-07,

];

Also attaching the qvw for reference.

HTH

Best,

Sunny