Converts a text string to a time­date value, where possible.

Syntax

@TextToTime( string )

Parameters

string

Text or text list. The string you want to convert to a time-date.

time-date

Time-date, time-date range, or list thereof. The string, converted to a time-date.

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

This function is useful for converting a date within a text field to a value that can be used for computation in a time­date field.

"Today", "Tomorrow", and "Yesterday" are the only legal strings to use to represent relative dates. The formula @TextToTime("Next week") returns a blank because the text string "Next week" cannot be converted to a time­date value.

@TextToTime returns an error If you try to pass anything besides a string into it, including a time-date value.

Language cross-reference

DateValue function of LotusScript language

TimeValue function of LotusScript language

CDat function of LotusScript language

Example
See Also

Converting data types
@TextToNumber
@Explode
Performing time-date operations
"Creating a calendar view in Lotus Notes" on the Lotus Developer Domain
@ToTime

Glossary