The TextToTimeValidate function is a built-in function that returns true if Text t can be converted to a Time value.

You can use this function before converting the Text value to a Time value with the TextToTime function.

Input parameters

t: Text Type

Output parameters

Boolean Type

Examples

Usage

Result

TextToTimeValidate( "12:12:12" )

True

TextToTimeValidate( "23:68:12" )

False

TextToTimeValidate( "0-0-0" )

False

TextToTimeValidate( "abc" )

False

Remarks

You should check the limits of the Time data type.

See Also

TextToTime Function | Available Conversion Functions to Time | Available Built-in Functions