General information
Category:
Coding, syntax & commands
Thanks again Robert,
How do you "set the cursor position to the start of the time area, highlight to end of field"?
Raymond
>Hello Raymond,
>
>Thats what I was talking about with the input structure, one way
>
>Var=DTOT(date())
>
>bind the variable to the input box
>set the cursor position to the start of the time area, highlight to end of field.
>
>Defaults to todays date 12:00, as soon as the user starts typing the existing time is replaced.
>
>Of course, if you write a timeclock routine, you can use the current time :)
>
>Another way to go is to interface with an electronic timeclock, prices have
>come down on these devices.
>
>Bob
>
>>Thanks Robert.
>>
>>How do you use or configure a DateTime field so the user only has the time to enter and no date?
>>
>>Raymond
>>
>>>Hello Raymond,
>>>
>>>Datetime will force users to enter a valid date & time without much checking on your part, as long as the users don't balk at the default input structure. You can also peform math calculation fairly easily.
>>>
>>>If you use a text field HH:MM you need to check the range for hours and minutes, and generally you would convert to a decimal version to do the math.
>>>
>>>EX: 12:30 = 12.50 (divide minutes by 60) and you also have to account for time that breaks over a boundry:
>>>
>>>02:00 - 10:00 = 4.00 (add 12 to the hours if it rolls over)
>>>
>>>I've done it both ways, easier with datetime, users liked entering the text method better, but only because of the code enforcing the input was more flexible because it was custom.
>>>
>>>Bob
>>>
>>>>What is the best way to do calculations with time?
>>>>
>>>>I have a time sheet to do where the users enter the time started such as 8:30 and the end time such as 13:20.
>>>>Should I use a character field for entry formated 99:99 or is a datetime better?
>>>>Are there pre existing functions to do the calculations?
>>>>
>>>>Thanks in advance.
>>>>
>>>>Raymond Larche
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only