i am using this in an expression to count the number of records received from 01/01/2013 to 31/01/2013 inclusive. the result should be 97 but it only returns 93 and ignores all records that are for 31/01/2013.
The problem is that your dates are actually timestamps. So the dates for 31/01/2013 are larger than 31/01/2013 00:00:00. You either need to use < 01/02/2013 or remove the time part of your dates, for example with floor([CMS Entered Date]) in the script.
The problem is that your dates are actually timestamps. So the dates for 31/01/2013 are larger than 31/01/2013 00:00:00. You either need to use < 01/02/2013 or remove the time part of your dates, for example with floor([CMS Entered Date]) in the script.
