Where Date

[bobbydave]

I am writing a Where statement to say

Load Audit.Date

from ..... (qvd)

where Date#(Audit.Date, 'DD/MM/YYYY') >= MakeDate(2013,12,28)

but Audit.Date is a text number as in 41266

How would I write the where statement to accommodate the Audit.Date is greater than 28/12/2013?

Thanks

[#2]

Hi Qlikview internally converts Date into number while storing into qvd.

LET vMinDate = Num(MakeDate(2013,12,28));

Load

     *

From qvd_name.qvd (qvd)

where

     Audit.Date >= $(vMinDate)

;

or Audit.Date >= Num(MakeDate(2013,12,28))

[Digvijay_Singh]

see if this works -

Load Audit.Date

from ..... (qvd)

where Date(Num(Audit.Date),'DD/MM/YYYY')>= Date(MakeDate(2013,12,28),'DD/MM/YYYY')

[avinashelite]

try like this :

where Date(Date#(Audit.Date), 'DD/MM/YYYY') >= MakeDate(2013,12,28)

[#5]

Try:

Where Date(Audit.Date,'DD/MM/YYYY')>='28/12/2013'

[sunny_talwar · Accepted solution]

May be this:

Load Audit.Date

FROM ..... (qvd)

Where Num#(Audit.Date, '##') >= Num(MakeDate(2013,12,28));

[maxgro]

if Audit.Date is date or a num (you said as in 41266)

....

where

     Audit.Date >= MakeDate(2013,12,28)

[MarcoWedel]

Hi,

one solution could be:

LOAD Date(Audit.Date) as Audit.Date
Inline [
Audit.Date
41266
41267
41268
41269
41270
41271
41272
41273
41274
41275
41276
41277
41278
41279
]
Where Audit.Date >= Date#('28/12/2012','DD/MM/YYYY');

(replacing the inline load with your qvd)

And check if there are dates at all after 28/12/2013 in your qvd.

41266 for example represents 12/23/2012 not 2013.

hope this helps

regards

Marco

[MarcoWedel]

depending on your DateFormat definition even

Where Audit.Date >= '28/12/2012';

should work.

regards

Marco