Nepethya Rana

Nepethya Rana

  • NA
  • 335
  • 145.8k

How to create calculated date colmn from existing date colmn

Sep 22 2017 1:33 PM
 I have tblStore which has FixtureDate.
Now I need to write a store procedure which will return the table but with extra column 'OpeningDate'
This OpeningDate will have FixtureDate + 10days.
How do i achieve this?
Please help me
 
tblStore    
stNum city FixtureDate
1 NYC 1/23/2017
2 NYC 1/23/2017
3 NYC 1/23/2017
 

Answers (2)