Current Time

[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?

[Steven H. Blackwell]

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

[Vaughan]

... 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.

[ibookuser2]

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.