Formula in Crystal 3

[blairclw]

I have a formula that pulls in years of service and it works and looks like this:
Datediff ("yyyy", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)

I would like to only see those that have with 1 or more years of service, not anyone less. How would I write that??

 

[jjames]

In selection formula...

Datediff ("d", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate) >= 365

 

[blairclw]

It shows me true or False....how do I see the actual number?

 

[blairclw]

What I'm trying to do is find the years of service but I want it to tell me the exact amount of service. So if they have only been here for say 8 months I don't want it to print a 1. I want to see the exact months so I can remove those from my list.

 

[MrBillSC]

The formula from jjames above goes in you record selection formula. It will only select records where the date difference is >= 365 days. This will eliminate records less than one year.
MrBill

 

[Madawc]

What you've got is a boolian, a test without an 'if' and which returns true or false.

If the name was @FindYear, you could test it as @FindYear = true, or just as @FindYear, and as not @FindYear if you want those that don't have the condition.

Madawc Williams (East Anglia, UK)

 

[blairclw]

Thanks! Works now!