Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Load Audit.Date
FROM ..... (qvd)
Where Num#(Audit.Date, '##') >= Num(MakeDate(2013,12,28));
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))
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')
try like this :
where Date(Date#(Audit.Date), 'DD/MM/YYYY') >= MakeDate(2013,12,28)
Try:
Where Date(Audit.Date,'DD/MM/YYYY')>='28/12/2013'
May be this:
Load Audit.Date
FROM ..... (qvd)
Where Num#(Audit.Date, '##') >= Num(MakeDate(2013,12,28));
if Audit.Date is date or a num (you said as in 41266)
....
where
Audit.Date >= MakeDate(2013,12,28)
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
depending on your DateFormat definition even
Where Audit.Date >= '28/12/2012';
should work.
regards
Marco