THE NOW FUNCTION AND ADD SOME

[gsc123]

Is it possible to add more days to the Now() function in a select statement or would I use a select to add 7 dyas plus the time now()?

 

[BigRed1212]

I think the exact syntax depends on what your database is but you should be able to use something like "dateadd".

Google it for the syntax for your database.

 

[gsc123]

When you say syntax what do you mean?

 

[vicvirk]

When you say syntax what do you mean?

You're joking, right? Seriously, you, as a self proclaimed Programmer, don't know what syntax means?

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[gsc123]

Yes jokin, thought I'd put it back up the list