small code problem

Joe8915

Registered User.
Local time
Today, 07:11
Joined
Sep 9, 2002
Messages
818
This is what I have so far
Def: IIf([30 day notification]<"1/1/2005","h")
What I need to accomplish is, any records less than 1/1/2005 show me "H". It does show up in some but not others. This is a date field. What is it that Iam doing wrong.

Doing my best at learning code. I don't know how you people learn this stuff

Thanks
 
Def: IIf([30 day notification]<#"1/1/2005"#,"h","Show Something Else")
 
I'm not sure if you still need those quotes since it's a Date field

How about:

Def: IIf([30 day notification]<#1/1/2005#,"h","Show Something Else")
 

Users who are viewing this thread

Back
Top Bottom