ibookuser2 Posted December 17, 2001 Share Posted December 17, 2001 I'm trying to write a script to set a field to the current time. It completely escapes me what function one uses to get the current time! I know there's the today function for getting the date, but I'm completely lost with the time. Help? Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted December 17, 2001 Share Posted December 17, 2001 quote: Originally posted by ibookuser2: I'm trying to write a script to set a field to the current time. It completely escapes me what function one uses to get the current time! I know there's the today function for getting the date, but I'm completely lost with the time. Help? How about InsertCalculatedResult (Status(CurrentTime)) Old Advance Man Link to comment Share on other sites More sharing options...
Vaughan Posted December 17, 2001 Share Posted December 17, 2001 ... and please don't use the Today function. Use Status(CurrentDate). Today only calculates when the database is opened, so after remaining open for several days on a server it'll be wrong. Link to comment Share on other sites More sharing options...
ibookuser2 Posted December 17, 2001 Author Share Posted December 17, 2001 Ah, thanks. I wondered why Today quit working, but it started working again as soon as I relaunched the database, so I thought it was fine. Thanks for explaining it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8165 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now