Date Query

Hi
I have a date column in my view "it_dtedelv"  and i need to create another column that would minus 3 days from the it_dtedelv column, so if the it_dtedelv column had a value of 2011-09-05

the new column would show a value of 2011-09-02

John
pepps11976Asked:
Who is Participating?
 
kemi67Connect With a Mentor Commented:
use this
 
select dateadd(day,-3,it_dtedelv) as data3, it_dtedelv from yourtable

Open in new window

0
 
pepps11976Author Commented:
brilliant thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.