<div>
&gt;but the dates that make up the current week or month<br />
What do you mean by this ... Monday, Tuesday, Wednesday?<br />
<br />
On most servers, 1=Sunday and 7=Saturday. &nbsp;Check that yours hasn't been altered.<br />
SELECT DATEPART(DW, GETDATE())
</div>


<div>
If you mean just return the day, i.e. 7-12-2013 returns 12..<br />
SELECT DATEPART(d, GETDATE())
</div>


<div>
Hi Thanks for your comments, no what I mean is GETDATE() i.e. 12/07/2013 - thats the format I want but I want to retrieve the array of dates that comprise this week e.g. 08/07/2013, 09/07/2013, 10/07/2013, 11/07/2013, 12/07/2013, 13/07/2013, 14/07/2013....is there a way to do that do you know?
</div>


<div>
@angelIII: VERY IMPRESSIVE!!! I would vote for your solution!
</div>


<div>
Wow! thank you both, amazing, I thought I was on a no-hoper with this but that is just brilliant, thanks so much.
</div>


<div>
Please note that my solution needs to be corrected.<br />
Change: &nbsp;WHERE DATEADD(day, 1, EndValue) &lt;&nbsp;@endDate<br />
to this: &nbsp; WHERE EndValue &lt;= @endDate
</div>


<div>
I found that the original query I posted showed only dates up to 2 days before the end of the period (in that case 29 rather than 31).
</div>


<div>
Oh yeh I see, I'm missing a day - now fixed perfect
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Quick one, is there a simple way to get the dates of the current month and or week using GETDATE() and datepart as suggested by my title?<br />
<br />
&nbsp;So to be clear I don't want the week number or month number but the dates that make up the current week or month...is this possible does anyone know??<br />
<br />
Many thanks in advance
</div>
</div>


Hi Experts,

Quick one, is there a simple way to get the dates of the current month and or week using GETDATE() and datepart as suggested by my title?

 So to be clear I don't want the week number or month number but the dates that make up the current week or month...is this possible does anyone know??

Many thanks in advance

&amp;gt;but the dates that make up the current week or month
What do you mean by this ... Monday, Tuesday, Wednesday?

On most servers, 1=Sunday and 7=Saturday.  Check that yours hasn&amp;#39;t been altered.
SELECT DATEPART(DW, GETDATE())

If you mean just return the day, i.e. 7-12-2013 returns 12..
SELECT DATEPART(d, GETDATE())

Hi Thanks for your comments, no what I mean is GETDATE() i.e. 12/07/2013 - thats the format I want but I want to retrieve the array of dates that comprise this week e.g. 08/07/2013, 09/07/2013, 10/07/2013, 11/07/2013, 12/07/2013, 13/07/2013, 14/07/2013....is there a way to do that do you know?

@angelIII: VERY IMPRESSIVE!!! I would vote for your solution!

Wow! thank you both, amazing, I thought I was on a no-hoper with this but that is just brilliant, thanks so much.

Please note that my solution needs to be corrected.
Change:  WHERE DATEADD(day, 1, EndValue) &amp;lt; @endDate
to this:   WHERE EndValue &amp;lt;= @endDate

I found that the original query I posted showed only dates up to 2 days before the end of the period (in that case 29 rather than 31).

Oh yeh I see, I&amp;#39;m missing a day - now fixed perfect

MS SQL - GETDATE() WHERE  DATEPART(m, GETDATE())

Hi Experts,

Quick one, is there a simple way to get the dates of the current month and or week using GETDATE() and datepart as suggested by my title?

 So to be clear I don&amp;#39;t want the week number or month number but the dates that make up the current week or month...is this possible does anyone know??

Many thanks in advance

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.