InaPlex Forums

Hi

How can I send the 'City' field from the Contsupp table across as a date field as I need to send across a creation date field.  So an example of the city field entry when record is created is "MASTER 2009031711:16AM".  I need to send this across as a date in format 17/03/2009. 

Many Thanks

Hi Sukhdeep

Not clear why you want to do this. The CITY field is used by GoldMine to store the user/createdate; nearly all contsupp rec types do this, and I would not advise doing something different.

You could store your information in the DEAR or FAX field perhaps.

Regards

Admin

Hi

I don't want to change the CITY field.  As the CITY field shows the date a record was created I want to send the date from the CITY field across to a field on my website.  So I create a record and it is stamped in CITY field as MASTER 2009031811:45am.  This is fine and I do not want to change this.  What I need Inaport to do is to get the date from this field and send it across to my date field on my website.

Cheers

Hi Sukhdeep

Sorry for misunderdstanding. the CITY field is a string, so the first thing is to extract the date:

find(#CITY, "\d{8}")    -  extract a sequence of 8 digit characters

Second is to convert this to a date:

s2d(find(#CITY, "\d{8}"), "yyyyMMdd")    -  convert string to date

You should now have a valid date field that can be mapped to the target.

Regards

Admin

Brilliant

That worked a treat

Many Thanks

Glad it worked.

Regards

Admin

Hi

I've read your post about the sql query to update the contsupp table and thought I'd try it but when I select the sql query match type, it reverts to "no match". I suspect that this factility is available only in the professional edition and not the standard version that I think I bought. Do you know if that's true and if so, is there anyway that I can update the contsupp table with a custom detail record using the standard edition/

Thanks for your help.

Kim

Duh! Wrong thread - my abject apology.

Kim

No problem