General information
Category:
Coding, syntax & commands
>I have a time field in a form like 08:30:00 (8:30am). If no time is entered in the time field its status is EMPTY(). But if a time is entered in the time field its status is NOT EMPTY().
>
>But what if the user enters a time such as 08:30:00 and then decides to blank it out and makes it " : : ". Then the time field status is blank and passes as NOT EMPTY().
>
>How can I reset the time field from blank to empty so when I check the time field for EMPTY() the time field is truly empty and not blank?
>
>Thanks. This is probably an easy one. But the blanks are really messing up my logic and time calculations.
Do a STRTRAN(TimeField, ":", "") to remove the colons.
Steve
Previous
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