Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add days to Date Column and Create New Date Column

Hello Guys,

I have column with Dates (YYYYMMDD) and a column with Days . I need to add dates +days = new date column

Kindly help.

Thanks,

Ravi

1 Solution

Accepted Solutions
sunny_talwar

Have you tried this?

Date(Dates + Days) as NewDate

or

Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate

View solution in original post

3 Replies
sunny_talwar

Have you tried this?

Date(Dates + Days) as NewDate

or

Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate

Anonymous
Not applicable
Author

Hello Sunny,

Thanks a lot .

Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate  . This worked for me .


Regard,

ravi

ashishpalkar
Creator III
Creator III

Hi Sunny

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)