Skip to Content
0
Former Member
Jul 12, 2007 at 10:24 AM

Selecting data according to condition

23 Views

hi,

I have a requirement where , i have to fetch data of employees who joined or left the organisation in the previous month.

The condition is : if i run the report on 11th July, 2007, ...the data fetched must be between 1st June and 30th June , 2007.

if i run the report on 23rd March , 2007...the data fetched must be between 1st Feb and 28th Feb, 2007.

How can i achieve this?