topic Re: Add days to Date Column and Create New Date Column in App Development

Add days to Date Column and Create New Date Column

Anonymous — Wed, 10 Jan 2018 15:22:06 GMT

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 — Wed, 10 Jan 2018 15:23:30 GMT

Have you tried this?

Date(Dates + Days) as NewDate

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

Anonymous — Thu, 11 Jan 2018 08:59:30 GMT

Hello Sunny,

Thanks a lot .

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

Regard,

ravi

ashishpalkar — Fri, 21 Sep 2018 11:23:15 GMT

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)