I can find first day of current and next month using SQL Server 2008
Thare is my code:
declare @date_begin date= DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)
declare @date_end date= CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@date_begin))-1),DATEADD(mm,1,@date_begin)),101)
select @date_begin, @date_end
It return me:
2013-12-01 2014-01-01
But now I need to get first day of current and next month using VBScript. Can somebody help me?
Best Answer
You can do same thing using DateSerial in VBScript.
From Remarks Section - DateSerial Function:
So, all you need is specifying year, month and day values.