Calculate Time

[MackBlale]

I have an input boxes on my form for "Contract Date" "Hire Date" and "First
Possible Payday"
A contract can be signed any day. After some background work is done the
candidate can be hired. However pay periods always start at the beginning
of the month. We pay 1 month in arears. If a candidate's hire date is
before the 8th of the month they can be paid on the 1st of the next month.
If it is after the 8th they won't be paid until the 1st of the next
following month. For example candidate signs their contract on the 3rd of
January, however their background check comes back on the 9th of January,
ttheir first possible paydate would be the 1st of March. How do I have the
text box "First Possible Payday" calculate this based upon the date entered
in "Hire Date"

Mack

 

[John W. Vinson]

I have an input boxes on my form for "Contract Date" "Hire Date" and "First
Possible Payday"
A contract can be signed any day. After some background work is done the
candidate can be hired. However pay periods always start at the beginning
of the month. We pay 1 month in arears. If a candidate's hire date is
before the 8th of the month they can be paid on the 1st of the next month.
If it is after the 8th they won't be paid until the 1st of the next
following month. For example candidate signs their contract on the 3rd of
January, however their background check comes back on the 9th of January,
ttheir first possible paydate would be the 1st of March. How do I have the
text box "First Possible Payday" calculate this based upon the date entered
in "Hire Date"

Mack

Try:

DateSerial(Year([Hire Date]),Month([Hire Date]) + IIF(Day([Hire Date]) <= 8,
1, 2), 1)

 

[MackBlale]

Thanks,
Worked like a charm!

Mack

I have an input boxes on my form for "Contract Date" "Hire Date" and
"First
Possible Payday"
A contract can be signed any day. After some background work is done the
candidate can be hired. However pay periods always start at the beginning
of the month. We pay 1 month in arears. If a candidate's hire date is
before the 8th of the month they can be paid on the 1st of the next month.
If it is after the 8th they won't be paid until the 1st of the next
following month. For example candidate signs their contract on the 3rd of
January, however their background check comes back on the 9th of January,
ttheir first possible paydate would be the 1st of March. How do I have
the
text box "First Possible Payday" calculate this based upon the date
entered
in "Hire Date"

Mack

Try:

DateSerial(Year([Hire Date]),Month([Hire Date]) + IIF(Day([Hire Date]) <=
8,
1, 2), 1)