Date range selection
I have a date field in the format xx/xx/xxxx. I am trying to calculate how many entries were done in a month over a period of time. For example, creation_date 12/11/10. When i create calculation fields with the following calculations:
CREATED_DATE ≥ "12/1/2010"and CREATED_DATE ≤ "12/31/2010"
I get a result (1 of course)
When I create the the following:
CREATED_DATE ≥ "12/1/2011"and CREATED_DATE ≤ "12/31/2011"
I also get a positive result.
Obviously, I am doing this only 1/2 right since I get a positive result.