Set Analysis for between Dates

Tue, 12 Nov 2013 02:17:07 GMT

Hi All,

Struggling with the the above topic.

I have two variables which I am trying to pass into a Set Analysis calculation.

I'm getting Zero returned as my total based on the following syntax. Is this correct?

=sum({<ServReadings.DateRecorded= { "$(= '>=' & date(vStartDate,'DD/MM/YYYY') & ' <=' & date(vEndDate,'DD/MM/YYYY'))" }>} Readings )

Regards

Steve

Re: Set Analysis for between Dates

jagan — Tue, 12 Nov 2013 04:13:54 GMT

Hi,

Try this expression

=sum({<ServReadings.DateRecorded= { ">=$(=date(vStartDate,'DD/MM/YYYY'))<=$(date(vEndDate,'DD/MM/YYYY'))" }>} Readings )

If not working then check whether the date formats are same in variable and DateRecorded.

Regards,

Jagan.