Date expression in Query

[Steve Stad]

I am getting 'undefined function' w/this expression in my qry.
Expr1: IIf(today()<[PoP_End_Dt],"cur","exp")

How do I insert or use todays date in a Query.

 

[Jerry Whittle]

Expr1: IIf(Date()<[PoP_End_Dt],"cur","exp")

 

[KARL DEWEY]

Access does not use 'today()' but Date() instead.

 

[Steve Stad]

Thanks Jerry -

Expr1: IIf(Date()<[PoP_End_Dt],"cur","exp")
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I am getting 'undefined function' w/this expression in my qry.
Expr1: IIf(today()<[PoP_End_Dt],"cur","exp")

How do I insert or use todays date in a Query.

 

[Steve Stad]

Thanks Karl

Access does not use 'today()' but Date() instead.
--
Build a little, test a little.

I am getting 'undefined function' w/this expression in my qry.
Expr1: IIf(today()<[PoP_End_Dt],"cur","exp")

How do I insert or use todays date in a Query.