Date Formula 1

[blairclw]

I have a report that shows me the employees HIREDATE. What I would like is to be able to only pull employees who's anniversary date is for the current month.....
{EmployeePos_Stat_Curr.LastHireDate}

 

[blairclw]

Sorry I copied over the other one I was using. This is what I have in there now and it still rounds the months up to one year. Here is what it looks like.

NAME POSITION HIRE DATE YEARS OF SERVICE
Ima Test Job-Position 9/28/2004 Year 1

Years of service should be Months 11 since September has not occured yet.


if Datediff ("yyyy",({EmployeePos_Stat_Curr.LastHireDate}), CurrentDate) < 1 then
"Months "& Datediff ("m", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)
else
"Years "& Datediff ("yyyy", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)

 

[blairclw]

strange but this actually worked in a differant report. Not sure why it doesn't work in the one report but I'll figure it out. Thanks for all yall's help.