Lookup.ini question - create date

[ddeegan]

Hello

I have a need for end users to use the create date of a record in filters.

I can update a date field based on the accountno in Contact2, but either the syntax in my Lookup is incorrect, or there is a problem with updating contact2 when a new record is created.

It doesn't look like a new record is automatically created in Contact2, is there a way to change this setting? (Make GM add a contact2 record when one is added to contact1)

Here is my Lookup.ini code...

[AutoUpdate]
NewRecord=udate5

[udate5]
Otherwise=&ctod(substr(accountno,3,2)+"/"+substr(accountno,5,2)+"/"+"0"+substr(accountno,2,1))
Overwrite=1

I've tried using "substring" instead of "substr", but didn't get this to work.

Any suggestions are appreciated.

Thanks
Dave

 

[richardy]

Hi,

ACCDATE(<string>)
returns a date value for <string>, where string is a valid GoldMine AccountNo.
example: ACCDATE(Contact1->ACCOUNTNO)
returns: 4/20/99
Regards,

Richard.

If you found this information useful, please visit:

http://crn.vnunet.com/CRN/Awards/index.jsp?section=reseller_vote

and Vote for Prior Analytics