• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

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
0
pepps11976
Asked:
pepps11976
1 Solution
 
kemi67Commented:
use this
 
select dateadd(day,-3,it_dtedelv) as data3, it_dtedelv from yourtable

Open in new window

0
 
pepps11976Author Commented:
brilliant thanks
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now