Setting value for Date()

[dvent]

Hi All,

Is it possible to set the date value for Date() when opening an Access database?

Currently I have a database that uses Date() and my staff change the date of the local machine to the beginning of the following week due to the way some queries are written. Is there a way that they could open the database and declare Date() rather than using the system date?

Thanks in advance
dvent

 

[Rich]

What will stop users from entering any date they want anyway if they're that determined?

 

[dvent]

What will stop users from entering any date they want anyway if they're that determined?

Hi Rich. There are a number of queries that calculate totals for things i.e. things that happened <Date(). If an event for example happens tomorrow the database will know about the date and if the user sets their machine up to be next Monday, this event will be classed as having happened.

The thing I'm thinking is that the setting / resetting of dates is a bit messy.

 

[Rich]

Hi Rich. There are a number of queries that calculate totals for things i.e. things that happened <Date(). If an event for example happens tomorrow the database will know about the date and if the user sets their machine up to be next Monday, this event will be classed as having happened.

The thing I'm thinking is that the setting / resetting of dates is a bit messy.

I'm sure I've seen a function somewhere over the years that will bypass the windows setting and get the true value elsewhere, I can't remember where it was though, maybe one of the other members can help

 

[Rich]

Try this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=158836&highlight=unc+time

 

[Access_guy49]

Couldn't you have a form pop up with a calendar control?
Get the user to select a date and save that value to a Global variable. Then just re-write your queries to use that variable? Or just reference the date directly from the form in your queries. To me that would be much esier than trying to circumvent pre-designed functions in windows.