Posted on 2011-02-15
I have a query that pulls some column values. One of the columns is a date called "Upload Date".
ex. Select this, that, theother, Uploaddate
Now I want to basically add 1 more column called "Completed Date" to my resultset. For this,I would need to tweak the Where clause.
ex. Select this, that, theother,CompletedDate
Then I want to Use DateDiff() function to get the days difference between "Upload Date" and "CompletedDate" and call that value "Turnaround" .
So essentially if we left the where clause out what I want is this :
ex. Select this, that, theother,UploadDate ,CompletedDate,Turnaround"
How to do it? Any advice would be greatly appreciated.