Value Prompt and Date Issue

[mahgar]

Hello Gurus,

I have a problem with the value prompt and date range. The AND function are not working with the logic that I implemented.

1. If Emp Status = Active, User will have to specify the Active Date Range (Active Hire Date – Active End Date); Report stores the "Hire Date" and "Termination Date".
2. This report will list all the employees if the "Hire Date" is on or before "Active End Date" and "Termination Date" is on or after "Active Start Date"
3. Active Start Date specified in the parameters in the report: 26-Jul-2014
   - All Termination Date in the report should show 26-Jul-2014 onwards. However, the report also shows Termination Date between 23-Jul-2014 and 25-Jul-202014.
4. Active End Date specified in the parameters in the report: 30-Jul-2014
   - All Hire Date in the report are on or before 30-Jul-2014


TIA!

[MFGF]

Hello Gurus,

I have a problem with the value prompt and date range. The AND function are not working with the logic that I implemented.

1. If Emp Status = Active, User will have to specify the Active Date Range (Active Hire Date – Active End Date); Report stores the "Hire Date" and "Termination Date".
2. This report will list all the employees if the "Hire Date" is on or before "Active End Date" and "Termination Date" is on or after "Active Start Date"
3. Active Start Date specified in the parameters in the report: 26-Jul-2014
   - All Termination Date in the report should show 26-Jul-2014 onwards. However, the report also shows Termination Date between 23-Jul-2014 and 25-Jul-202014.
4. Active End Date specified in the parameters in the report: 30-Jul-2014
   - All Hire Date in the report are on or before 30-Jul-2014


TIA!

Hi,

So what is your filter expression? It's rather difficult to debug it unless we know what it is :)

MF.