>>Any ideas on how to put a date field in a grid textbox with this format? Or am I 'barking up the wrong tree' trying to do this?
>
>That's not very specific, let's try again...I have the datetime field in the column using TIME() but the time is showing HH:MM:SS.Milleseconds. I've tried to set seconds OFF in both the textbox and with SET SECONDS, but neither of them work. ???
>
>It's an editable field so I can't split into parts with other functions like HOUR()...
I use a numeric field of 4 digits, no decimals. Stores data on 24 hour clock. so 1340 is 1:40 pm, etc.
Have special functions ttocx() and ctotx() that convert numeric time to 99:99 am/pm and back.
Have spinners that when last two digits reach 59 are incremented to 00 and push hour up and when reach 00 and going down, jump to 59 minutes.
You get the idea. Works nice.