Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have column with Dates (YYYYMMDD) and a column with Days . I need to add dates +days = new date column
Go to Solution.
Have you tried this?
Date(Dates + Days) as NewDate
Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate
Thanks a lot .
Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate . This worked for me .
How to execute below SQL statement which has Dateadd function?
Thanks in advance.
ISNULL(I.maturitydate,I.ExpiryDate) between @BusinessDate AND DATEADD(d,@DaystoMaturity,@BusinessDate)