Add days to Date Column and Create New Date Column

[Anonymous]

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

[sunny_talwar · Accepted solution]

Have you tried this?

Date(Dates + Days) as NewDate

or

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

[Anonymous]

Hello Sunny,

Thanks a lot .

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

Regard,

ravi

[ashishpalkar]

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)