IIf statement

Hi, I'm pretty new to this and am trying to make a multiple IIF
statment work. I'm trying to create a date based on current date and a
constent month and day. I want to create expiration date that is bi
annual ODD on 3-31 of the next odd year.
This is what I have ..what am I doing wrong.
AptExpDate: IIf(Year(Date()) Mod 2=0 ,"03-31-" & Year(Date())
+1,IIf((Year(Date()) Mod 2=0) and ((Month(Date()) 4), "03-31-" &
Year(Date()),"03-31-" & Year(Date())+2
Please help I'm stuck
I keep getting errors about not the correct number of arguments or not
the correct opening or closing ( or[
Thanks, Tim

Hi Tim:

'From the debug (immediate) window
? dateserial(year(date()) + switch(year(date()) mod 2 = 0, 1, month(date())4,
0, true, 2), 3, 31)
3/31/07

'Explanation: The Switch() function is generally less messy than nested
Iif's.
'year(date()) mod 2 = 0 indicates it's currently an even numbered year, so +
1
'month(date())4 indicates (based on first statement) that's an odd numbered
year, so if current date less than 1 April add 0 else add 2

HTH - Bob

wrote:
Hi, I'm pretty new to this and am trying to make a multiple IIF
statment work. I'm trying to create a date based on current date and a
constent month and day. I want to create expiration date that is bi
annual ODD on 3-31 of the next odd year.
This is what I have ..what am I doing wrong.
AptExpDate: IIf(Year(Date()) Mod 2=0 ,"03-31-" & Year(Date())
+1,IIf((Year(Date()) Mod 2=0) and ((Month(Date()) 4), "03-31-" &
Year(Date()),"03-31-" & Year(Date())+2
Please help I'm stuck
I keep getting errors about not the correct number of arguments or not
the correct opening or closing ( or[
Thanks, Tim

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200702/1

wrote:

Hi, I'm pretty new to this and am trying to make a multiple IIF
statment work. I'm trying to create a date based on current date and a
constent month and day. I want to create expiration date that is bi
annual ODD on 3-31 of the next odd year.
This is what I have ..what am I doing wrong.
AptExpDate: IIf(Year(Date()) Mod 2=0 ,"03-31-" & Year(Date())
+1,IIf((Year(Date()) Mod 2=0) and ((Month(Date()) 4), "03-31-" &
Year(Date()),"03-31-" & Year(Date())+2


DateSerial(IIf(Year(Date()) Mod 2 = 0 , Year(Date())+1,
IIf(Month(Date()) 4, Year(Date()), Year(Date())+2)),
3, 31)

--
Marsh
MVP [MS Access]

On Feb 18, 11:20 am, "raskew via AccessMonster.com" u28575@uwe
wrote:
Hi Tim:

'From the debug (immediate) window
? dateserial(year(date()) + switch(year(date()) mod 2 = 0, 1, month(date())4,
0, true, 2), 3, 31)
3/31/07

'Explanation: The Switch() function is generally less messy than nested
Iif's.
'year(date()) mod 2 = 0 indicates it's currently an even numbered year, so +
1
'month(date())4 indicates (based on first statement) that's an odd numbered
year, so if current date less than 1 April add 0 else add 2

HTH - Bob

wrote:
Hi, I'm pretty new to this and am trying to make a multiple IIF
statment work. I'm trying to create a date based on current date and a
constent month and day. I want to create expiration date that is bi
annual ODD on 3-31 of the next odd year.
This is what I have ..what am I doing wrong.
AptExpDate: IIf(Year(Date()) Mod 2=0 ,"03-31-" & Year(Date())
+1,IIf((Year(Date()) Mod 2=0) and ((Month(Date()) 4), "03-31-" &
Year(Date()),"03-31-" & Year(Date())+2
Please help I'm stuck
I keep getting errors about not the correct number of arguments or not
the correct opening or closing ( or[
Thanks, Tim

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200702/1


THANK YOU BOTH,
Thats exactly what I needed.