Please help with selection formula

[CRuser89]

Hello everyone,

I need help with a selection formula. I currently have a report that has employee division, month, and year as the parameters.

The wage table that I'm pulling from has a salary date column.

I'm trying to come up with a formula so that if a user puts in 08 for August and 2005 for the year, it will go and pull the information from the wage table for anything that has a salary date in 07/2005, 08/2005 or 09/2005. I'm trying to get it to look based on fiscal quarter. So if a user puts in 05 and 2005 as the parameters, it will look for salary date of 04/2005, 05/2005, and 06/2005 and not just 05/2005. I hope this makes sense.

Can someone please help?

Thanks,
cruser89

 

[lbass]

Try the following record selection formula:

datepart("q",{table.salarydate}) = datepart("q",date({?year},{?month},01))

-LB

 

[CRuser89]

Thanks LB...I get the following error when i try to add that to the record selection:

too many arguments have been given to this function....

Thanks,
cruser89

 

[lbass]

I just tested this and it works. You should check to make sure you have the parens in the right places.

-LB