|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Feb date problem
Hi All,
I am writing schedule program that is tied to our payroll...so it rolls over every two weeks. In the below code I want the text box to show as long as its equal to the current year. The problem results with Feb, access thinks there are 31 day in Feb 05!!!! =(IIf(Year([startdate]+70)>Year([startdate]),"",[StartDate]+70 & " - " & [StartDate]+83)) Is there a way to fix this or another way to do this? Thanks |
|
#2
|
|||
|
|||
|
Your formula is incoherent. To begin with, Year(startdate) +70 = 2074 (based on the current year) according to your formula. What does this have to do with the number of weeks? The rest of the formula has no meaning. If you state your problem in plain english as to what you wish to accomplish and give a real value example, We'll be pleased to pull you back from your next payday in 2074 and make sure that you will get paid every 2 weeks accurately, leap years uncluded, until the week you retire.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Feb date problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|