Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ravishinge
Contributor

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

Re: Add days to Date Column and Create New Date Column

Have you tried this?

Date(Dates + Days) as NewDate

or

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

3 Replies

Re: Add days to Date Column and Create New Date Column

Have you tried this?

Date(Dates + Days) as NewDate

or

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

ravishinge
Contributor

Re: Add days to Date Column and Create New Date Column

Hello Sunny,

Thanks a lot .

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


Regard,

ravi

ashishpalkar
Contributor II

Re: Add days to Date Column and Create New Date Column

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)

Community Browser