Created On:  11 August 2010

Problem:

How do you modify the Date field in a project that has been exported from a CaliberRM database that will be imported to another CaliberRM database?

Resolution:

The dates used in the export file are automatically converted into UNIX format. If you wish to modify the export file to change the dates then you will need to convert the dates first into UNIX format, then save the changes and then import the file back into CaliberRM and the changes will be reflected. The information below provides more on UNIX formats:

11/08/2010  corresponds to 1281524400, hence this is the value that will need to be entered into the file before importing the project into a CaliberRM database.

If you need help in converting given dates into UNIX format please refer to the following link which converts the date format for you.

http://www.fourmilab.ch/documents/calendar/
Incident #2470110