Mar 1, 2011 #1 jtarry IS-IT--Management Mar 10, 2010 22 GB select statement select date1, date2, date1 - date2 from table required result: 28/02/11, 27/02/11, 1
select statement select date1, date2, date1 - date2 from table required result: 28/02/11, 27/02/11, 1
Mar 1, 2011 #2 dhulbert Technical User Jun 26, 2003 1,136 GB Have a look at Datediff. I love deadlines. I like the whooshing sound they make as they fly by Douglas Adams (1952-2001) Upvote 0 Downvote
Have a look at Datediff. I love deadlines. I like the whooshing sound they make as they fly by Douglas Adams (1952-2001)