Hello everyone!,
I am having a bit of trouble producing the results I need. I am trying to assign a tier level based on the persons hire date. If they have been here less than four years from today's date it will assign a "1" value or else "2". What I have below is not producing the results I need and I believe it has something do with the format "YYYY" and I don't think i have this formatted correctly. Here is an example of the hire date showing an incorrect tier assignment. The difference between the two dates is greater than 4 years and therefore should be assigned a level 2.
Hire Date Date() Tier
1/2/2013 8/9/17 1
TierLevel: IIf(DateDiff("yyyy",[SomeTable]![HireDate],Date())<4,"1","2")
Thanks!
I am having a bit of trouble producing the results I need. I am trying to assign a tier level based on the persons hire date. If they have been here less than four years from today's date it will assign a "1" value or else "2". What I have below is not producing the results I need and I believe it has something do with the format "YYYY" and I don't think i have this formatted correctly. Here is an example of the hire date showing an incorrect tier assignment. The difference between the two dates is greater than 4 years and therefore should be assigned a level 2.
Hire Date Date() Tier
1/2/2013 8/9/17 1
TierLevel: IIf(DateDiff("yyyy",[SomeTable]![HireDate],Date())<4,"1","2")
Thanks!