Last 6 months of New Hires

[agray123]

I want to run a report that gathers all new hires by months: month({Hire_Date}).

I only want to display the last 6 months from currentdate, grouped by month, the year end wraparound is confusing me.

In other words I only want to see people hired in the last six months...I should know this one....

 

[synapsevampire]

You're probably overthinking it:

Select Report->Edit record selection formula->Record and place:

{table.date} >= datadd("m",-6,currentdate)

Insert a group by the date and select group will be printed for each month.

Now you can use normal summaries, etc and the data is properly filtered.

-k

 

[agray123]

correct...I was expending way too much effort...and after a walk..it came to me! Thanks