Date Range Calculation

[joebeachcomber]

In our SQl database our projects have a start and an end date. I am trying to calculate the number of days that each project lasts. I have tried both

DateDiff ('D', startdate, enddate)
and
(enddate - startdate)

and I get the same results. All projects equal to zero days whether it was the same date or 15 days difference in the start and end dates.

Thoughts?

 

[MJRBIM]

EndDate - StartDate should work.

What format are the StartDate and EndDate fields in the SQL database - Dates, DateTimes, Strings?

 

[synapsevampire]

I believe that it's case sensitive, use a lowercase d, but the enddate - startdate should work fine. Try right clicking this date field and selecting browse data and post what the type of data is, and what's being displayed.

Also try posting technical inforamtion, such as Crystal version and the database used (a SQL database could be numerous as it's a language, perhaps you mean a SQL Server database)

-k