Date expression in Query

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

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.
 
Thanks Jerry -

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


Steve Stad said:
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.
Click to expand...
Click to expand...
 
Thanks Karl

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


Steve Stad said:
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.
Click to expand...
Click to expand...
 
Back
Top