Skip to Content
0
Former Member
Jan 17, 2011 at 05:55 PM

Display current and previous months records only

258 Views

Hello gang,

My selection criteria looks like this:

not ({HRDEPBEN.PLAN_CODE} startswith ["C", "EAP", "HMIL", "V", "W"]) and
(month({hrdepben.Creation_date}) = month(currentdate)) and
{HRDEPBEN.PLAN_TYPE} = "HL"

I modified it to this in order to pull in previous month's data too:

{HRDEPBEN.PLAN_TYPE} = "HL" and
not ({HRDEPBEN.PLAN_CODE} startswith ["C", "EAP", "HMIL", "V", "W"]) and
(month({hrdepben.Creation_date}) = month(currentdate) or month ({hrdepben.Creation_Date})= month (currentdate)-1)

However, it's still pulls the same record count and only January records, not Decembers'.

Where am I going wrong?

Thanks