AnsweredAssumed Answered

Need to determine the 12th of the month

Question asked by dchabot on Aug 29, 2012
Latest reply on Aug 29, 2012 by dchabot

Hi,

 

I need to indicate whether or not an employee worked on the 12th day of each month during a reporting period.

The reporting period would be for each quarter.

 

This is the exact information needed:

 

12th of the month - month 1

Indicate whether or not the employee worked on the 12th day of each month during the reporting period.

Enter "1" if the employee worked during the week in the third month of the quarter that contained the 12th of

the month. Enter zero if the employee did not work during the period.

 

12th of the month - month 2 - same as above

12th of the month - month 3 - same as above

 

 

The pay date field may not necessarily be exactly the 12th day of the month.

 

For example:

1/6/2012

1/13/2012 = "1"

1/20/2012

1/27/2012

 

2/3/2012

2/10/2012

2/17/2012 = "1"

2/24/201

 

3/2/2012

3/9/2012

3/16/2012 - "1"

3/23/2012

3/30/2012

 

Let M1 = "week of the month that has the 12th in it"

Let M2 = "week of the month that has the 12th in it"

Let M3 = "week of the month that has the 12th in it"

 

It's the 3rd week (5 days) of each month range: Month(Week of Month=3 ???

 

What is the formula to give the week of the month that has the 12th in it?

 

This could then be:

 

Case(PayPeriod=M1;1

PayPeriod=M2;1

PayPeriod=M3;1;0)

 

Excuse any of my thought processes above, as I'm starting to ramble on.......

This is possible to do in FM isn't it?

 

Thanks so much

 

DChabot

FM11 Adv

Outcomes