Date Format

[dunnalahk]

Hi,

I have one QVD in that i have one Month Field.

so when i try to filter in where condition by giving as below it's not returning me any Rows

Load * from XXX.qvd

where Month >='201801'

is it some problem with month field format ? can some help me.

Best Regards

HK

[MK9885]

Is that a month field or Year Month field?

Where condition seem to be correct

[marcelviegas]

TRY,

Load * from XXX.qvd

where date(Month,'YYYYMM') >=date#('201801','YYYYMM')

[dunnalahk]

Hi,

Format is below

[sunny_talwar]

You can also try this

Load * from XXX.qvd

where Month >=MakeDate(2018, 1)

[dunnalahk]

Hi,

It is working but when i try to join with my Data period BMT QVD  based on month it is not working

Load * from XXX.qvd

where date(Month,'YYYYMM') >=date#('201801','YYYYMM')

Inner JOIN

LOAD Year,

     Quarter,

     Month,

FROM

[$(QVD_Path)\DataPeriod.qvd]

(qvd)

Problem  is Format not coming as Expected from source QVD, that's the reason when i try to join with my BMT its not working as per below snapshot

you can see 43221 is coming for 201805 month

and 43252 is coming for 201806 month

;

[marcelviegas]

try,

Load * from XXX.qvd

where date(Month,'YYYYMM') >=date#('201801','YYYYMM')

Inner JOIN

LOAD Year&Month as month,Quarter

FROM

[$(QVD_Path)\DataPeriod.qvd]

(qvd)

[marcelviegas]

it's easier if you attach qvw

[dunnalahk]

Hi Sunny,

it works as i said in my earlier reply.

but the problem i if i join with my data period BMT QVD month to month it's not working as expected.

could you help me please.

Best Regards,

HK

[sunny_talwar]

So, is your problem just the format or you think that the join isn't correct?