Prev: Average interpurchase times
Next: Combining Dup Info
From: Steve Stad on 14 Apr 2010 11:53
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.


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


"Steve Stad" wrote:

> 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.
>
>
From: KARL DEWEY on 14 Apr 2010 12:08
Access does not use 'today()' but Date() instead.
--
Build a little, test a little.


"Steve Stad" wrote:

> 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.
>
>
From: Steve Stad on 14 Apr 2010 13:35
Thanks Jerry -

"Jerry Whittle" wrote:

> Expr1: IIf(Date()<[PoP_End_Dt],"cur","exp")
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Steve Stad" wrote:
>
> > 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.
> >
> >
From: Steve Stad on 14 Apr 2010 13:35
Thanks Karl

"KARL DEWEY" wrote:

> Access does not use 'today()' but Date() instead.
> --
> Build a little, test a little.
>
>
> "Steve Stad" wrote:
>
> > 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.
> >
> >
 | 
Pages: 1
Prev: Average interpurchase times
Next: Combining Dup Info