[SIMS] Strange report using effective dates

[dav3ma1kin]

Hi,

 

I am running a report in SIMS which is just Surname Forename, Eligible for free meals, Free meals start/end dates, Free Meals History start/end dates. Output is in Excel. When it is run as of today with no effective date it returns exactly what is being asked. If we change the date to any other effective date (even yesterday) then it brings no historic data through.

 

Can anyone else replicate this? or is it our system just not liking Monday mornings?

 

Thanks in advance.

 

Dave

[blueday]

I can replicate this! When you change the Effective Date, any FSM periods with an end date are not reported in the Free meals History subreport.

[dav3ma1kin]

Thanks, at least I'm not going daft...well...

 

Now I just need to find out why I can no longer do it.

[blueday]

I'm sure the Capita Service Desk would say it is expected behaviour

[dav3ma1kin]

Just not who is expecting it.