I am getting a Type Mismatch Error. It occurs In Lotus Script either when I do a ComputeWithForm or Refresh.
All of my editable fields are Valid upon saving.
I have read that Computed Date Time fields that save a “”, of Text datatype, to the backend or Date Time Fields that resolve to a number data type both cause Type mismatch errors.
The Date Time Fields I have don’t have Formula language Formula. The value comes from Lotus Script after the form is computed.
Currently they have the Field Name typed into the formula area. That resolves as a text “”.
What formula can I put in there that wouldn’t cause an error ?
I have tried @ThisValue
@TextToTime(@ThisValue)) both still convert and save a “” TEXT datatype.
Is it possible to pass a NULL date Time Datatype or just leave it uninitialized until I put a value in it ?
Subject: “Null” Date Time for computed Date Fields
That would work unless the date has to be seen when the document is being edited by someone, which depends on the purpose of the field.
It depends on the field and how Lotus Script is expecting the Item.
If it is an editable field and doesn’t have anything in it yet, then it “IS Nothing”, versus an Invalid blank value “”.
That might be better in some instances than setting a Valid date time such as 01/01/0100. Lotus Script CDat (0) = 01/01/0100.
I’ll have to go field by field.
Apparently X-pages doesn’t like Text in Date Fields of its datasource documents. I can understand that.
It puzzles me a bit that in order to create a New NotesDateTime CLASS in Lotus Script you give it a “”, a text value, but when you save a “” to a date/Time FIELD it is an Invalid Text data type.