Getting Server Date in Var for SQL Lookup

[lloydanderson]

Hello;

I am very new to ASP and Databases - I am trying to get today's date for an ASP Page - The SQL statement is used in a query to an Access97 database. I would appreciate any help.

Thank you

 

[techMom]

It's been awhile since I have been in Access but I think the funtion is now(). In SQL it is getdate().

 

[krappleby025]

access code = Date()
asp code = Date

at least that is what i use

 

[lloydanderson]

Thank you both - The solution worked perfectly.