Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I want to load data in my qv document limiting the with cut off date
I have below script in my data load script
let bDate=num(date(makedate(2021,06,30)));
ctype,
$(vDate)-date as NOD
FROM
$(vPath)LTHSALES.qvd
(qvd)
where num(date)>$(bDate)
but it does not work properly.
Kindly help me to solve it please
Date hamdling can be tricky sometimes. The first thing I would check if my default date format is the same as the format of my source. If not, them it you might get in trouble using num(date).
Try this expression to see what you get.
ctype,
$(vDate) as vDate,
$(bDate) as bDate
date,
num(date) as date_num
FROM
$(vPath)LTHSALES.qvd (qvd)
//where num(date)>$(bDate)
;
Are all your date fields recognised as dates/numerics?
Date hamdling can be tricky sometimes. The first thing I would check if my default date format is the same as the format of my source. If not, them it you might get in trouble using num(date).
Try this expression to see what you get.
ctype,
$(vDate) as vDate,
$(bDate) as bDate
date,
num(date) as date_num
FROM
$(vPath)LTHSALES.qvd (qvd)
//where num(date)>$(bDate)
;
Are all your date fields recognised as dates/numerics?
@MyAARPMedicare wrote:
Hi Friends
I want to load data in my qv document limiting the with cut off date
I have below script in my data load script
let bDate=num(date(makedate(2021,06,30)));
ctype,
$(vDate)-date as NOD
FROM
$(vPath)LTHSALES.qvd
(qvd)
where num(date)>$(bDate)
but it does not work properly.
Kindly help me to solve it please
Is there a way to limit the records imported based on date to save time/space? Our system has 20 years of data and if we only want to import the last 5 or 10 years. Is this possible?