Calculate Dates 2

[rpangel]

hello everyone,

i was wondering if anyone knew what the reserved word is to get today's date in a SQL statement... i'm trying to write a query that will subtract the current date from yesterday's date without having to manually insert and change the dates. i thought i could use 'date$' but it doesn't work. does any one have any ideas...

TIA (thanks in advance)
angel

 

[THoey]

Look at the DATE() and the NOW() functions in Access help... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[rpangel]

i didn't find anything in access help under those words...

 

[SyedAqif]

Terry is rite

Ur query should be something like that

Select Date1 , date(), Date1-Date() from mytable;

date() will return todays date.

Hope it works.

Cheers!
Aqif

 

[rpangel]

THANK YOU,
You were right all along. I appreciate the help.

 

[wellskmac]

I need to get the diff between dates EXCLUDING weekends. I need to find out how many business days tasks take.

 

[braindead2]

wellskmac,

You might want to start a new thread for this since it is entirely different from the original post. But before that I suggest you look into the keyword search as there have been numerous postings on this subject matter.
good luck