Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
count({$<[CMS Entered Date]= {'>=01/01/2013<=31/01/2013'} >} [CMS Entered Date])
please advise where i am going wrong.
thanks
vijay
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.
Hi
Do you can post your QVW file.
I do a example and worked perfectly
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.