Date reference in an IIF statement

  • Thread starter Thread starter Presto
  • Start date Start date
P

Presto

The following statement works well. It is the default value for a payment.
However, every year I have to go in and change the year.

=(IIf(Date()>#3/31/2010#,"$45.00","$40.00"))

I would like to have it look at 3/31/(of whatever year it is) so I dont have
to reprogram this every year. How do I change the date reference?

Thanks in advance.
 
The following statement works well. It is the default value for a payment.
However, every year I have to go in and change the year.

=(IIf(Date()>#3/31/2010#,"$45.00","$40.00"))

I would like to have it look at 3/31/(of whatever year it is) so I dont have
to reprogram this every year. How do I change the date reference?

Thanks in advance.
Click to expand...

=IIf(Date() >DateSerial(Year(Date()),3,31),"$45.00","$40.00")
 
Sorry, Linq, but that won't work in October, November or December since
you're using string comparisons.
 
The following statement works well. It is the default value for a payment.
However, every year I have to go in and change the year.

=(IIf(Date()>#3/31/2010#,"$45.00","$40.00"))
Click to expand...

IIF(Date() > #3/31#, "$45.00", "$40.00")

will work. If you don't specify a year in a date literal, Access fills in the
current year for you.
 
Sorry, I missed the fact that you were comparing to #3/31#, not "3/31"

Yes, it should work, but using DateSerial is far safer than using implicit
data coercion.
 
Back
Top