I have a third party import program which imports deals into Goldmine. When doing so, the time of the record is not recorded in the normal place as per other processes which do a similar function (Import Wizard for example). Ive tried amending the import program to insert the time from a remote table which stores both date & time by using the substring function but it throws an error since the datatype of the remote table which holds this data is smalldatetime format. No source code is available for this app so this process cannot be amended.
Since Im not able to get the above process to work, I thought of doing this another way - either create a new goldmine field and insert the data from the remote table into this and query this field. Or - somewhere else in Goldmine the time of the record creation can be obtained from. Reason Im trying to do this is so I can identify deals by time of creation via a crystal report.