Creating a Query

Creating tables and queries

Creating a Query

Postby ErbeerichR » Tue Dec 08, 2015 10:54 pm

I am trying to create a Data Base and Query to help keep track of clients who need to be contacted after their first contact. This re-contact should not happen until at least 7 days after the initial contact.

I want the query to sort them by the initial contact date (which I have no problem doing) but only pull list the clients who's 'hold date' is more than 7 days old, based on the current date. IE, when I open the query, it automatically pulls up the data.

Thanks for any assistance.
Roy
OpenOffice 4.0.0 on Windows 7 Professional
ErbeerichR
 
Posts: 1
Joined: Tue Dec 08, 2015 9:20 pm

Re: Creating a Query

Postby Villeroy » Wed Dec 09, 2015 12:07 am

Just like with any other database:
Code: Select all   Expand viewCollapse view
SELECT * FROM "Clients" WHERE DATEDIFF('dd',"Date",CURRENT_DATE)>=7;
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27728
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 6 guests