I need to write a query similar to one below--
SELECT col1, col2 from table1
where to_date(col3,'DD-MON-YY') between '01-||<month accepted from the form> || '-' || current year) and
...
http://www.experts-exchange.com/Programming/Misc/Q_21061652.html
Zones:
ProgrammingDate Answered: 08/18/2004 Grade: A Views: 0
I am trying to create a query by a date range. I have a query based on a form called "Security_Check_Database. On the form I have two unbound textboxes called "startdate" and "enddate" and a button...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21803364.html
Zones:
MS AccessDate Answered: 04/05/2006 Grade: A Views: 0
I have the following query but I need to modify it so it only returns a specified date range.
<cfquery name="rsSchedule" datasource="#mm_outlawsilverbacks_dsn#">
SELECT Games.GameID, Games.Game...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21865357...
How can I add this date range:
AND eventdate >= convert(datetime, '2006-04-01', 120) AND eventdate < convert(datetime, '2006-05-01', 120)
To this query sucessfully:
SELECT SUM(circulati...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21895344.html
Zones:
DatabasesDate Answered: 06/23/2006 Grade: A Views: 0
SELECT MESSAGE.userid, COUNT(MESSAGE.userid) AS 'Count Of Teams', usertable.firstname, usertable.lastname
FROM MESSAGE INNER JOIN
usertable ON MESSAGE.userid = usert...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21943358.html
I have a "Between" date range parameter for a query field named "Date of Service". How can I utilize these same dates as criteria for another field in the same query, without having the user prompt...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22037836.html
Zones:
MS AccessDate Answered: 10/26/2006 Grade: A Views: 0
Hi,
I am working on MSSQL 2000
I want query help
I want data between the date range
The date in the database is in the form 2007-04-23 17:23:57.280
I wish to pass the date in the f...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2254...
I have a query that has a date field. In its criteria I use a date range. This will return something like:
dt batch_id
11/19/2007 LP076
11/19/2007 LP074
11/19/2007 LP073
11/19/2007 LN079
11...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22982161.html
Zones:
MS AccessDate Answered: 11/27/2007 Grade: A Views: 0
I have a table which holds information on scanned in invoices. Data held includes the invoice number (field1) which is unique and the scanned in date and time(ScanDateTime). I have written the fo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21336105.html
Ok I need to get the number of submissions that have been submitted this month from a MySQL DB this is for a web page that is using ASP the below is the query I have so far. the field start_date i...
http://www.experts-exchange.com/Database/MySQL/Q_21690273.html
Zones:
MySQL ServerDate Answered: 01/09/2006 Grade: A Views: 0
