Lotus Notes : Insert date value in Lotus Notes form using java agent

Question

I am trying to upload the data from a delimited text file to the lotus notes form using java agent. The issue arises when I try to insert the date value to the notes document. After insert when i use ComputeWithForm, then it returns false. I am using simpledateformat to format the date in MM/dd/yyyy format, but it is still not working. Below is the excerpt from my code.

         String delim, key,  thekey, myDate;
            Date date = new Date();
            SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy);
            myDate = dateFormat.format(date);
newdoc.replaceItemValue("UploadDBDate", myDate);

Any help will be great.

Thanks, Himanshu

Richard Schwartz Richard Schwartz · Accepted Answer · 2013-05-09T14:42:04

myDate is a String object. The replaceItemValue method does not know that you have put a date into that String, therefore it treats it as ordinary text. If uploadDBDate is a DateTime field, that causes a type mismatch during the computeWithForm operation.

The Lotus classes for Java include a DateTime class. The Session class has a createDateTime method that you pass a "mm/dd/yyyy" string and return a DateTime object. Then you can pass that DateTime object into replaceItemValue instead of passing in myDate.

Lotus Notes : Insert date value in Lotus Notes form using java agent

2 Answers