Discussion Board for collaboration on QlikView Scripting.
I am currently trying to add a column of days (labeled 'Aging') to a column of Dates (labeled 'Reportdate'), but my code keeps breaking my table. My information is coming from an excel sheet.
My current code is as follows: Date(Date#(Reportdate,'YYYY-MM-DD')+ Aging) as NewDate
What am I doing wrong and how do I fix it?
Thank you in advance.
Go to Solution.
Date#() -> is used to interpret the data.
Example: Date#('17/06/2019', 'DD/MM/YYYY') means that the first two digits are day, the second two digits are months and last 4 digits are year.
Data() -> is used to show the data.
Example: Date(today(), 'YYYY-MM-DD') means that you want to show the data with the format as your parameter.
Both functions together:
Date(Date#(Reportdate,'YYYY-MM-DD') + Aging, 'YYYY-MM-DD')