04-01-2015 02:25 AM - edited 04-01-2015 02:37 AM
Our database has 1 annual reminder task setup for each company in our Act! V16 database.
I need to get the date of each task into a new custom date field called 'Reminder Date' that I have created for company records.
Is there any way I can extract this data using a SQL query and then match it back and populate these fields without
having to do this manually for all 5,000 records.
04-06-2015 12:20 PM
04-07-2015 01:37 AM
Yeah that was my line of thinking as well but I'm unsure of the connection details for the db. I tried the Act! admins credientials but they didnt work. I'm confident I'd be able to write the query to do this. Think I'll run it up on our development server and give it another go.
04-07-2015 07:07 AM