Counting days in date fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • teneesh
    New Member
    • Mar 2007
    • 46

    Counting days in date fields

    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
  • teneesh
    New Member
    • Mar 2007
    • 46

    #2
    found it!!!


    datediff(day,da tefrom, dateto)

    Comment

    Working...