December 17, 200124 yr 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?
December 17, 200124 yr 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
December 17, 200124 yr ... 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.
December 17, 200124 yr Author 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.
Create an account or sign in to comment