Very simple question

[jrelis]

Can someone tell me the syntax for the current date in MS query?
Thanks

 

[SkipVought]

Hi,

Date()

Skip,

_[red][/red]

 

[jrelis]

I need to get the current date , date () in MS query doesn't do this

 

[PHV]

What is the database type you attempt to query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

It certainly is!

What does Date() return for you?

Skip,

_[red][/red]

 

[jrelis]

The DB is an AS400 and Date() asks for the parameters so Date(1) will give me 0000-00-01 result.

 

[jrelis]

Date(now()) seemed to do the trick , thanks

 

[SkipVought]

Well, don't you think that AS400 is VITAL to the question???

If it were Oracle or DB2 it would be SYSDATE and not Date().

Try SYSDATE.

After all, this is an ACCESS formum, not AS400.

Skip,

_[red][/red]

 

[jrelis]

Thanks for all the help

 

[PHV]

Furthermore, AS400 is NOT (AFAIK) a DBMS ...