Solved

Date Query

Posted on 2011-09-27
2
252 Views
Last Modified: 2012-05-12
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
Comment
Question by:pepps11976
2 Comments
 
LVL 7

Accepted Solution

by:
kemi67 earned 500 total points
ID: 36708345
use this
 
select dateadd(day,-3,it_dtedelv) as data3, it_dtedelv from yourtable

Open in new window

0
 

Author Comment

by:pepps11976
ID: 36708371
brilliant thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question