By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,361 Members | 1,345 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,361 IT Pros & Developers. It's quick & easy.

Counting days in date fields

P: 46
I have to count the difference between two dates, to determine how many days exist between them. How do I do this? Can someone guide me to a good place please?

date from date to
2008-02-18 00:00:00 2008-02-29 00:00:00 - how do i count the number of
2008-03-01 00:00:00 2008-03-02 00:00:00 days in between?
2008-03-14 00:00:00 2008-03-16 00:00:00

thank you
Jun 26 '08 #1
Share this Question
Share on Google+
1 Reply

P: 46
found it!!!

datediff(day,datefrom, dateto)
Jun 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.