Urgent- date issue

[sg24]

Hi Folks,

I have filter in the query and the columns in the called hiredate and termination date . these two col are coming from the data base. And there is one more col called Effective date which is a calculated column with case statements.

I have a filter included in the report as effective date <=termination date and effective_date>=hiredate.

Now i need to take the hiredate and termination date based on the effective date and pull that hiredate and termination date in the report. 

Please let me know if u folks hav any idea...

Thanks,
Shilpa

[MFGF]

Hi,

I'm not clear on what you mean by

Now i need to take the hiredate and termination date based on the effective date and pull that hiredate and termination date in the report.

What does "pull ... in the report" mean? You want to remove them? Pull them in? Pull them into some sort of calculation? Pull them around to different locations?

If you can be more specific about what you're trying to do, we may be able to help.

Regards,

MF.

[sg24]

Thank you for the response. I meant to include the column in the list. However that is resolved now.  :)