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?
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?
