Re: [MS_AccessPros] Effective Date for Employee Raises

 

John,

You are correct in that it gets me close. It gives me a Saturday. If I add +1 at the end, it gives me the Sunday that I want!

Thanks for your help!!

Doyce

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Doyce-

This will get you close:

Raise Date = DateOfReview + (7 - Weekday(DateOfReview))

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Sep 6, 2017, at 4:17 PM, winberry.doyce@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello Pros,

At my plant, we do employee performance reviews every 6 months based on an employee's hire date or rehire date. Then they get a pay raise that is effective the first Sunday after their review date. For example, an employee is hired on Jan. 18, 2017. His first review is July 18, 2017 and the effective date of his raise would be on July 23, 2017. I have automated a report that runs on the 1st of every month and prints out the reviews that will be due the following month. That gives the supervisors a whole month to get the reviews done before the effective pay raise date. What I want to do is calculate the effective date for the raise and include that on the review but I'm not sure how to do that. How can that be accomplished?

Thanks in advance.

Doyce 

__._,_.___

---

Posted by: winberry.doyce@con-way.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___