<div>
Apologies for the late response <br />
thanks to you both for your responses - I couldn't get aneeshattingals one to work &nbsp;problem with casting.- but angelIII worked brilliantly - <br />
I changed it to be<br />
&nbsp;yourfield &lt;= dateadd(day, &nbsp;- datepart(day, getdate()), convert(datetime, convert(varchar(10), getdate(), 120), 120) ) &nbsp; <br />
to get the last day of the previous month ..<br />
Is this the best way to do the same for the month before that.<br />
yourfield &lt;= &nbsp;dateadd(month,-1,dateadd(d<wbr />ay, 1 - datepart(day, getdate()), convert(datetime, convert(varchar(10), getdate(), 120), 120) ) &nbsp; )<br />
<br />

</div>


Apologies for the late response
thanks to you both for your responses - I couldn't get aneeshattingals one to work  problem with casting.- but angelIII worked brilliantly -
I changed it to be
 yourfield <= dateadd(day,  - datepart(day, getdate()), convert(datetime, convert(varchar(10), getdate(), 120), 120) )  
to get the last day of the previous month ..
Is this the best way to do the same for the month before that.
yourfield <=  dateadd(month,-1,dateadd(day, 1 - datepart(day, getdate()), convert(datetime, convert(varchar(10), getdate(), 120), 120) )   )



<div>
yes. the dateadd(month, -1) ... will take care of any 31/30/29/28 days per month.
</div>


yes. the dateadd(month, -1) ... will take care of any 31/30/29/28 days per month.

<div>
Excellent and aneeshattingal solution worked as well :-)
</div>


Excellent and aneeshattingal solution worked as well :-)

<div>
<div class="content wysiwyg-content">
Hello<br />
I have a table where I extract data for a given day - I want to compare this data with data from previous month - but only the data for the last entry for the previous month - how would I do this?<br />
<br />

</div>
</div>


Hello
I have a table where I extract data for a given day - I want to compare this data with data from previous month - but only the data for the last entry for the previous month - how would I do this?



get max date record entered in previous month

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.