imtheodore
Registered User.
- Local time
- Today, 06:56
- Joined
- Jan 20, 2007
- Messages
- 74
I have an
admitdatetime----->01/01/2013 00:22:00
and
dischargedatetime ---->01/09/2013 22:56:29
I need to calculate the number of days between the two, when I use
(datediff (d, admitdatetime,dischargedatetime)
I only get the correct number of days a small number of times
0-14 hours = 1 day
24:01-48 hours = 2 days
etc...
But using the datediff function the number of days often comes up a day short
Thanks
admitdatetime----->01/01/2013 00:22:00
and
dischargedatetime ---->01/09/2013 22:56:29
I need to calculate the number of days between the two, when I use
(datediff (d, admitdatetime,dischargedatetime)
I only get the correct number of days a small number of times
0-14 hours = 1 day
24:01-48 hours = 2 days
etc...
But using the datediff function the number of days often comes up a day short
Thanks