CODEWITHSUNDEEP
lotus-noteslotus-dominolotusscriptlotuslotus-formula
Lekhwair Alatan
Lekhwair Alatan

Reputation: 49

Lotus Notes data saved as text field convert to date/time

Old form that will be replaced by a New, and add a new view.

Old form has:

Expiration Date = Text field

New form:

Expiration Date = Date/Time field

View contains Exp. Date and Days Left. Problem is Expiration Date of existing data is saved as a Text field. Days Left column read the Exp. Date as a text instead of Date/Time field. So the Days Left column's output is:

ERROR: Incorrect data type for operator or @Function

Is there a way to convert all the existing date's field to date/time instead of text so the Days Left column's info will be correct? except to re-input the dates manually because the data are too many.

Upvotes: 0

Views: 1856

Answers (1)

Tode
Tode

Reputation: 12060

Just create a formula agent with one line of code:

FIELD ExpirationDate := @TextToTime( ExpirationDate )

And let it run on all documents that contain fields with the wrong type.

Of course you could do some error handling in your code as well as:

_newVal := @TextToTime( ExpirationDate );

FIELD ExpirationDate := @If( @IsError( _newVal ); SomeFallbackValue ; _newVal )

Upvotes: 3

Related Questions