Manage Learn to apply best practices and optimize your operations.

Don't change created date of a Lotus Notes document via LotusScript

This user wants to know if it's possible to modify the created date of a Notes document and a Notes database --either with (or without) LotusScript or with another Windows utility.

VIEW MEMBER FEEDACK TO THIS TIP

Is it possible to change or modify the created date of a Lotus Notes document and a Notes database – either with (or without) LotusScript or with another Windows utility.

Cregg Hardwick:The obvious approach is to change the system date in the computer you are using, then cut and paste the documents. This will wipe out the $modifiedby and $revisions system fields (and modifying these fields directly is not a good idea). But it is very likely that you will end up creating more problems when you replicated back to the server. The bottom line is, you are not meant to modify the created date, and you are playing with fire, your job and possibly the law if you do so. Being able to modify document creation dates would compromise, among other things, the ability to perform audits and respond to data requests related to litigation or regulation. (And since the CIA is a major client for Notes, I wouldn't invest much time in trying to get around this one.)

In theory, you could modify the database file directly. I have had some success with using a hex editor to modify certain information in a non-encrypted database without going through one Notes client, but I'll leave that dangerous exercise to your own ingenuity. FYI: Exporting the data to DXL, changing the created date, and re-importing it will not work--it will set the created date to the date you do import.

MEMBER FEEDBACK TO THIS TIP

One simple way is to create a new document based on the old one is to Call notesDocument.CopyAllItems( notesDocument [, replace ] ). Now, the same document has a new creation date.
—Paul R.

Cregg Hardwick is Collaboration Solutions Technical Lead for CenterPoint Energy in Houston. He has an MBA, a PCLP and an MCAD and has been a Notes developer since 1998. He focuses on collaboration and business process support applications. If you have a question for Cregg Hardwick on LotusScript, send it to editor@searchdomino.com and simply write "LotusScript question for Cregg" on the subject line.

Dig Deeper on LotusScript

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Well, actually... if you read the following 3 articles, it will make clear how to change the document created date:

http://www-01.ibm.com/support/docview.wss?uid=swg21112556

http://www-01.ibm.com/support/docview.wss?uid=swg27002668

http://www-12.lotus.com/ldd/doc/domino_notes/9.0/api90ug.nsf/85255d56004d2bfd85255b1800631684/00d000c1005800c985255e0e00726863?OpenDocument

Just calculate and change the document ID and voila.
Cancel

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close