Set Analysis for between Dates

[#1]

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

[jagan]

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.