WILL WORK FOR CODE! Need help with date fields

[airbus2]

I have to track when an employee initially recieved their badge, the day it expires, and the day they actually renewed it.

The first field is a date field called "Initial", it represents the date they were issued a badge. The second date field called "Recurrent" represents the date the employee actually came in and renewed their badge. I have an unbound field "Expire Date" (not sure if thats the best way to do it) that should display an annual date of 730 days (2 years) from the day they initially got their badge, or 365 days (1 year) from the day they renewed the badge.

Code would flow something like this in an If/then statement:
If Recurrent = Null the Expire = Initial + 730. If not Expire = Recurrent + 365.

I need help designing the right code. Both fields are within the same table.

 

[SkipVought]

Hi,

Will code for peanuts! ;-)

Expire: IIf(Recurrent = Null , Initial + 730 , Recurrent + 365)

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[Remou]

airbus2
If you are out of peanuts, you could try appeasing SkipVought by clicking on :
Thank SkipVought
for this valuable post!

;-)

 

[PHV]

for better results, either:

Expire: IIf(Recurrent Is Null , Initial + 730 , Recurrent + 365)

or:

Expire: IIf(IsNull(Recurrent), Initial + 730 , Recurrent + 365)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

What PH didn't explicitly state is that Null can't equal anything so [blue]Recurrent = Null [/blue] won't work.

Duane
Hook'D on Access
MS Access MVP