>>>In one of our projects that deals with scheduling, there is some difficulty in ascertaining the best way to deal with time. If we use a datetime field, we have to deal with an interface which forces the user to enter a space before he can enter the time. If we separate out the date and time fields now we have to all the time math ourselves, which forces to build our own time text control.
>>>
>>>Is there a third party tool that deals with these problems or perhaps some solutions that would make the datetime fields a little more user friendly?
>>>
>>>TIA
>>
>>You can separate interface's textboxes and still have one datetime field.
>
>That sounds great. How would you implement that?
I would have bunch of textboxes (probably as members of container). When it comes to refresh interface it will collect data from the datetime field:
With Thisform.cntDatetime
.txtDate.value=TTOD(mytable.myfield)
.txtHour.value=HOUR(mytable.myfield)
.txtMinutes.value=MINUTE(mytable.myfield)
.txtSeconds.value=SEC(mytable.myfield)
Endwith
When you're ready to save a record, you validate the Values, concatenate Date+Time string ans save CTOT() to the field.
Edward Pikman
Independent Consultant