8/18/2025 4:28:39 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.
|
|
|
|
View Accounts with most recent history occuring before a certain date
Posted: 18 Mar 08 4:34 PM
|
I need to be able to create a group containing accounts whose most recent history, exluding database changes, occured before a certain date. I know that there is a field called Lasthistorydate, but filtering on this will not get the job done due to a previous error by our business partner with a custom automated dialer (they didn't set it up to write to the Lasthistorydate field when it entered a note in the history table).
What SQL query will accomplish this? Select AccountID, MAX(CreateDate).....
I am just learning SQL,I How can I do this?
 |
|
|
| |
|
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!
|
|
|
|
|
|
|
|