I have a unique request from upper management for a dashboard.  They would like to track new unworked leads that come into the system in hourly buckets.

Essentially we would have a table on the dashboard that broke down like this:

New Leads:

1 hour      ||   30

2 hours    ||   30

3 hours    ||   30

4 hours    ||   30

5+ hours  ||   30

---------------------

Total Unworked Leads || 150

The problem is that while the creation date is a date/time field I can't seem to calculate based on the hour of creation...just the date.

Anyone have any ideas?

Finally...can anyone tell me why this formula:

CloseDate - DATEVALUE(Orig_Lead_Create_Date__c)

...would always give me a value of "0"?

In theory if I had a creation date of 03/18/08 11:15am and a close date of 06/30/08 then this formula should strip the timestamp off and just leave me with 06/30/08 - 03/18/08...which equals 104....but that's not what I'm coming back with :(

Appreciate the help!

P.