Current Date

I'm trying to create a query that will show all funds where the fund's
effective date is less then today. Something like <NOW() or <Date(). This
has to be simple but I just can't seem to get it to work.On Jan 2, 5:14=A0pm, John <J...@.discussions.microsoft.com> wrote:
> I'm trying to create a query that will show all funds where the fund's
> effective date is less then today. =A0Something like <NOW() or <Date(). ==A0This
> has to be simple but I just can't seem to get it to work.
Depends what you are writing the query in, but in T-SQL <GETDATE() is
what you would need