Conditional Text within a report?

[AC5FF]

I'm having problems getting this to work and I do not understand why. As far as I can tell everythign is written correctly - it just doesn't seem to want to work!

In the report I am working on I list a set of work center test stations. The report itself works great and does exactly what I need it to do. Now, the work center has to comply with an inspection on the test station every week. They have chosen Thursday's to do these inspections but would like a reminder to pop up on the report so it is not forgotten.

Inside the report I put this line:

=IIf((Date(),"ddd")="Thu" And [Station Type]="ADTS","*** ADTS 7 Day Inspections Due ***","")

So, I should get the line "*** ADTS 7 Day Inspection Due ***" on every ADTS test station on Thursdays only. Instead I get that line every day. It does only appear against the "ADTS" stations and none of the others - so that part is working. But with the ' DATE(),"ddd"="Thu" ' shouldn't it only work on a Thursday?

Any help you can give would be greatly appriciated!

Thx

 

[PHV]

=IIf(Weekday(Date())=5 And ...

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

 

[AC5FF]

PH
Thanks! Your help fixed this right up..
Makes me wonder though why the DATE(),"ddd"="Thu" didn't work... Wierd...

 

[SkipVought]

"Makes me wonder though why the DATE(),"ddd"="Thu" didn't work... Wierd... "

=IIf([b]Format[/b](Date(),"ddd")="Thu"....

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]