Discussion Board for collaboration on QlikView Scripting.
I am new to QV, so please bear with me,
I need to calculate the age of stock items, so, in the load script i want to subtract the stock created date (dd/mm/yy) from the today (run date).
how can i achieve this please.
Go to Solution.
Just substract the two dates and you will get no of days. You can also use the AGE() function to get the age in years.
SET DateFormat='DD/MM/YYYY'; //Environmental variable
today()-CreateDate as AgeDays,
Age(today(), CreateDate) as AgeYears
View solution in original post
Many thanks, this worked for me,
today()- BLOTLOT_CREATED as "AgeDays"