 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2006Program a date
Im trying to find a way to put todays date into a querys where. I want the date to change with the computers date. date need to go in looking like 1/18/2006 jln, Use a calculated query column... TodaysDate : Date()  Signaturehth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." > Im trying to find a way to put todays date into a querys where. I want the > date to change with the computers date. date need to go in looking like > 1/18/2006 I would love to be able to program my dates. Think of all the fun I could have :) > jln, > Use a calculated query column... [quoted text clipped - 3 lines] > > date to change with the computers date. date need to go in looking like > > 1/18/2006 I'd like to discuss my social life, but... that would be dating myself. :-D Al >I would love to be able to program my dates. > [quoted text clipped - 7 lines] >> > date to change with the computers date. date need to go in looking like >> > 1/18/2006 There is a Date function. That returns the computer's date. Field: TodayIs: Date() or in criteria Criteria: = Date() Access will probably strip off the () at the end. If you have a field named Date then you may have a problem with this - which is a good reason to never name a field Date, but to always give it a name like StartDate or SaleDate. If you have that problem and cannot fix the field name, you can use DateValue(Now()) to return the date. > Im trying to find a way to put todays date into a querys where. I want the > date to change with the computers date. date need to go in looking like > 1/18/2006 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.