Change Field data type from Text to Date/Time

HCL Domino Domino Forum
1

We have a database that we have made some changes to the design of and need to update the properties of one field. Apparently, when this database was created there was a date field created with a data type of text. We have fixed this in the changes we’ve made but there are over 2600 documents in the database that we need to update the properties of this field on. I would like to find a way to create an agent or something in which I could select all the documents and run it to change the data type on this field only. We don’t want to open the documents or change the contents of the fields. So far I have only found third party tools that will do this for me which I am considering.

Thank You in advance for any help.

2

Subject: RE: Change Field data type from Text to Date/Time

If you get the value of the field, you can conver it to a datetime value (NotesDateTime class in Lotus Domino Designer help) you can then take this value and set the field on the document by using the NotesItem’s DateTimeValue property. You can set it to be a DateTime value field instead of text.

  1. First get the text to be a DateTime (NotesDateTime class)

  2. Set the field to the DateTime value (NotesItem class: Date Time Value property)

Good Luck!

Tim Williams