Advertisement

09.10.2007 at 06:17AM PDT, ID: 22817510
[x]
Attachment Details

SQL - Query for date less than or equal to current date and 12 months in the past.

Asked by jfsedlar3rd in SQL Query Syntax, MS SQL Server

Tags: date, less, than, sql, query

I need to write a Transact SQL query that returns a record set based on a date criteria that returns records less than or equal to current date and no earlier than 12 months prior to current date. Can anyone help me?Start Free Trial
[+][-]09.10.2007 at 06:20AM PDT, ID: 19860686

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.10.2007 at 06:21AM PDT, ID: 19860694

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Query Syntax, MS SQL Server
Tags: date, less, than, sql, query
Sign Up Now!
Solution Provided By: gbshahaq
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628