In my GM database, their is no date value for companies, everything is always related to a contact.
I would like for example to migrate only companies from 2011 (and also all contacts belonging to this company).
What I think is: I look after the first created contact in the company, retrieve the createon date from this contact that could likely be considered as the creation date of this company. From here, I have the creation date of the company. After that, for my first job 'Account + contact' I have to specify that I only want to migrate companies based on dates (year, date range).
How could I do this ?
I already tried this SQL query in the origin tab of my job but has expected, it only creates my the contacts from this date range.
select * from contact1 c1 inner join contact2 c2
where c1.lastdate>'2012-06-01 00:00:00.000' AND c1.lastdate<'2013-01-01 00:00:00.000'
Login or sign up for our forums to connect to the user community.