Find First Day and last Day of Month

Posted by Sunil Soni under Sql Server category on 9/13/2011 | Points: 40 | Views : 2659

Post Code |

Search Codes |

Code Home

DECLARE @Month smallint
SET @Month = 1
SELECT DAY(DATEADD(Month, DATEDIFF(Month, -1, getdate()) - 2, -1) + 1) as FirstDayofMonth,
DAY(DATEADD(Month, DATEDIFF(Month,0,getdate())+@Month, -1)) as LastDayOfMonth

Alert Moderator

Bookmark It

Comments or Responses

Posted by: Pervej on: 9/22/2011 Level:Starter | Status: [Member] | Points: 10

http://getproductprice.com/Search.aspx?c=0-0-0&f=month

Latest Code Snipptes

Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
How to add star rating and submit rating
MS Dynamics 365 - Create an email activity using dynamics crm Rest API - C#
More ...