I was working on a sql query and it looks like this but i am not having any luck with it.
SELECT C1.*, C1.CREATEON
FROM CONTACT1 AS C1
WHERE (((C1.CREATEON <= current_date and CREATEON >= DATE_SUB(current_date(),INTERVAL 7 day));
I want to be able to build a filter or query that will pull records that have been updated or created with the last 7 days or so without having to go in and edit/rebuild the filter every time I want to use it. Is there a way to do this?
Im using Goldmine 6.7 DBase not SQL.
Now we use this both as a CRM tool but also we are trying to use it to do our calling from. We have 3 dif reps that will be calling out of Goldmine. I have filters set up to divy up the records between the 3 reps.
Here is what I am stuck at. I want to...
I work for a small business to business call center and i am the database admin. Our IT is outsourced.
Now my IT contact is saying we need to replace 2 of our APC smart UPS 700. He said that they are flashing indicating a control problem.
Now the 5 battery lights are blinking on both of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.