Month calculation

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

What am i doing wrong?

If Month(Me.Billingdate) = 1 Then
Me.[PeriodID].Value = 2
End If

If date is 28-01-2004 is should return 1 meaning periodid=2
The month doesn't compute right somehow. I don't get a good value. What am i
doing wrong here....

Any suggestions on how to efficiently set the period for a given date? The
idea is that the bill gets payd following the month it was filed. So bill
january gets payed february. Following the above i have to make 12 if then
statements. Is there a more efficient way?

Thanx for any tips.

Regards,
Harmannus
 
You don't say what the "doesn't compute right somehow" means?

However, an efficient way to do what you seek:

Me.PeriodID.Value = (Month(Me.Billingdate) Mod 12) + 1
 
Hallo,

I didn't retern the right period to match the periodid value....

But you suggestion did the trick ;-) Great. Thanx for the help.

Regards,
Harmannus


Ken Snell said:
You don't say what the "doesn't compute right somehow" means?

However, an efficient way to do what you seek:

Me.PeriodID.Value = (Month(Me.Billingdate) Mod 12) + 1


--
Ken Snell
<MS ACCESS MVP>

Harmannus said:
Hallo,

What am i doing wrong?

If Month(Me.Billingdate) = 1 Then
Me.[PeriodID].Value = 2
End If

If date is 28-01-2004 is should return 1 meaning periodid=2
The month doesn't compute right somehow. I don't get a good value. What
Click to expand...
am
i
doing wrong here....

Any suggestions on how to efficiently set the period for a given date? The
idea is that the bill gets payd following the month it was filed. So bill
january gets payed february. Following the above i have to make 12 if then
statements. Is there a more efficient way?

Thanx for any tips.

Regards,
Harmannus
Click to expand...
Click to expand...
 
Back
Top