PDA

View Full Version : Brain Dead about Time()


ABC123

Fred Daniel
02-03-2005, 06:09 PM
Its been a long while since I've used a time filed in an application. I just want to have the user enter a time in a field call, you guessed it! Time: and have it formated as normal time like system time. How can I use a non calculated field and set the default to the system time?

Steve Workings
02-04-2005, 02:17 AM
There are a couple ways to do this. What I do is create a character field, 5 chars long.

Then, in field rules / data entry tab / Default Mode, set this expression:

time()

This function returns the current time in hh:mm:ss format. Since the character field is only 5 long, it will just use the first 5 characters, e.g. hh:mm. If you want the seconds, just make your field longer.

Hope this is what you wanted.

- Steve