Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried this?
Date(Dates + Days) as NewDate
or
Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate
Have you tried this?
Date(Dates + Days) as NewDate
or
Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate
Hello Sunny,
Thanks a lot .
Date(Date#(Dates, 'YYYYMMDD') + Days) as NewDate . This worked for me .
Regard,
ravi
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)