Date Add Query confusing

[Guest]

PERCENT:
IIf(Now()<DateAdd("yyyy",+1,[HPDATE]),"4%",IIf(Now()<DateAdd("yyyy",+2,[HpDate]),"5%",Null))

2PERCENT:IIF(NOW()<DATEADD("YYYY"+7,
[HPDATE]),"7%",IIF(NOW()<DATEADD("YYYY",+15, [HPDATE]),"9%",NULL))

Can anyone please explain to me the difference in these two lines. The
first one runs fine, the second tells me it wrong and will not work. I had
them combined but it still would not run and kept getting hung on the +7. I
cannot see what I have done wrong but I am sure it's something simple. Thanks

 

[John Vinson]

PERCENT:
IIf(Now()<DateAdd("yyyy",+1,[HPDATE]),"4%",IIf(Now()<DateAdd("yyyy",+2,[HpDate]),"5%",Null))

2PERCENT:IIF(NOW()<DATEADD("YYYY"+7,
[HPDATE]),"7%",IIF(NOW()<DATEADD("YYYY",+15, [HPDATE]),"9%",NULL))

Can anyone please explain to me the difference in these two lines. The
first one runs fine, the second tells me it wrong and will not work. I had
them combined but it still would not run and kept getting hung on the +7. I
cannot see what I have done wrong but I am sure it's something simple. Thanks

The first has a comma between "yyyy" and +1. The second does not have
the (required) comma between "YYYY" and +7.

Note that you can leave the + off; it's not needed, since +7 and 7 are
the same number. Also, Now() is NOT today's date; it's the current
date and time accurate to microseconds. You might want to use Date()
instead.

John W. Vinson[MVP]

 

[Guest]

Thank you knew it had to be something simple.

PERCENT:
IIf(Now()<DateAdd("yyyy",+1,[HPDATE]),"4%",IIf(Now()<DateAdd("yyyy",+2,[HpDate]),"5%",Null))

2PERCENT:IIF(NOW()<DATEADD("YYYY"+7,
[HPDATE]),"7%",IIF(NOW()<DATEADD("YYYY",+15, [HPDATE]),"9%",NULL))

Can anyone please explain to me the difference in these two lines. The
first one runs fine, the second tells me it wrong and will not work. I had
them combined but it still would not run and kept getting hung on the +7. I
cannot see what I have done wrong but I am sure it's something simple. Thanks

The first has a comma between "yyyy" and +1. The second does not have
the (required) comma between "YYYY" and +7.

Note that you can leave the + off; it's not needed, since +7 and 7 are
the same number. Also, Now() is NOT today's date; it's the current
date and time accurate to microseconds. You might want to use Date()
instead.

John W. Vinson[MVP]