 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2004Eligibility Date question
I need to show in a report when an employee will be eligible for a certain benefit. The eligibility is basically the first day of the first calendar quarter AFTER one complete year of employment. For example, if a person's hire date is 9/5/2003, he becomes eligible on 10/1/2004, which is one year (9/5/2003 to 9/5/2004), plus the first day of the next quarter, which is 10/1/2004. If his hire date is 10/1/2004, he won't be eligible until 1/1/2006, which is one year (10/1/2004 to 10/1/2005), plus the start of the next quarter which is January of 1006. Does anyone have any idea how I can accomplish this using [HireDate] as the starting point? I hope this is clear! Susan Try it like this... Eligibility: DateSerial(Year([HireDate])+1-(Month([HireDate])>9),(DatePart("q",[HireDate])*3+1) MOD 12,1)  SignatureSteve Schapel, Microsoft Access MVP > I need to show in a report when an employee will be eligible for a certain > benefit. The eligibility is basically the first day of the first calendar [quoted text clipped - 5 lines] > next quarter which is January of 1006. Does anyone have any idea how I can > accomplish this using [HireDate] as the starting point? I hope this is clear! Perfect! Thanks very much, Steve! > Susan > [quoted text clipped - 13 lines] > > next quarter which is January of 1006. Does anyone have any idea how I can > > accomplish this using [HireDate] as the starting point? I hope this is clear! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.