Calculating a Historical Sum Table

Hi,

I have a table that contains a column for date created and date completed of each record. I am looking to create a new table to track the number of open records for each day of the year, so that I can display the historical trends of open records.

I've created a new table using the Calendar function, but I am having trouble creating a second column to sum the number of open records for each day. When I try to use the calculate function, I get an error anytime I try to use the date field created with the calendar function.

The two criteria that I am trying to use is the date created must be after the date row of the new table, and the date row needs to be before the date completed.