AnsweredAssumed Answered

Date range selection

Question asked by BrettTrusko on Jun 23, 2011
Latest reply on Jun 23, 2011 by BrettTrusko


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.