4/29/2026 10:44:05 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
Query help - No history in 6 months
Posted: 25 Jul 08 2:40 PM
|
I need all contacts that have no history in the past 6 months from today.
contact table: ContactId
history table: HistoryID, ContactID, Completeddate |
|
|
|
Re: Query help - No history in 6 months
Posted: 26 Jul 08 12:42 AM
|
I'm not sure I understand what you need all that well. You asked for all contacts that have no history in the last six months - but then you list fields for some reason, and I wonder if you want, instead, all history that is older than 6 months. I'll answer the first question and see if that does it.
SELECT ContactID, Lastname, FirstName FROM Contact WHERE NOT EXISTS (SELECT 1 FROM History WHERE Contact.ContactID = History.ContactID AND CompletedDate > DateAdd(month, -6, GetUTCDate()))
Hope that does it. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|