Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date formula...

Status
Not open for further replies.

Albano

Instructor
Dec 11, 2000
221
PT
Please, I need to now how, can i make a formula that calculate the current day and month without using the systwm date.

Thanks.

Albano
 
That's Impossible!!!!
If you don't use the system clock you have no reference.
Do you want to key in todays date somewhere? DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.
Or visit my WEB site
 
I don't think you can unless you:

1. Allow internet access to go to that National Repository that keeps all the time thingies (sorry, can't remember the technical term)

2. Create a timer function that would allow you to store the date in Access and then keep adding to it. This would require that the Access app be running constantly and would, in my opinion, be an unwise option.

I could be wrong...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top