Page 1 of 1
PICTURE time
Posted: Wed Mar 14, 2007 2:52 pm
by Maurizio
Is it possible to have a PICTURE for the time() like "00:00:00"
Regards Maurizio
Posted: Wed Mar 14, 2007 3:24 pm
by James Bott
Have you tried "99:99:99" ?
Posted: Wed Mar 14, 2007 3:56 pm
by driessen
Maurizio,
I use "99:99" as a time picture. It works very well. The only thing is that you have to type the leading zero (like 01:35).
Michel
Posted: Wed Mar 14, 2007 4:33 pm
by James Bott
Maurizio and Michel,
Might I suggest making a smart control that allows different forms of time entry then formats it when the user leaves the field.
135 becomes 01:35
1350 becomes 13:50
35 becomes 00:35
This way the use doesn't have to enter the colon or the leading zero and the data still ends up formatted properly.
And how about letting the user enter "now" and the program would automaticlly insert the current time. And maybe -10m for 10 minutes ago, or -2h for two hours ago.
James