Some time we required to find out the current date , first and last date of previous or next month. We can use below code for all these requirements.
This code return the First and last Date of previous month , Current date , last date of current month and first date of next month.
- DECLARE @TODAY_DATE DATETIME;
- SELECT
- @TODAY_DATE = GETDATE();
- SELECT
- CONVERT(
- VARCHAR(25),
- DATEADD(
- DD,
- -(
- DAY(@TODAY_DATE) -1
- ),
- @TODAY_DATE
- ),
- 103
- ) AS DATE_,
- 'FIRST DATE OF PREVIOUS MONTH' AS DATE_NAME
- UNION ALL
- SELECT
- CONVERT(
- VARCHAR(25),
- DATEADD(
- DD,
- -(
- DAY(@TODAY_DATE)
- ),
- @TODAY_DATE
- ),
- 103
- ) AS DATE_,
- 'LAST DATE OF PREVIOUS MONTH' AS DATE_NAME
- UNION ALL
- SELECT
- CONVERT(
- VARCHAR(25),
- @TODAY_DATE,
- 103
- ) AS DATE_,
- 'TODAY DATE' AS DATE_NAME
- UNION ALL
- SELECT
- CONVERT(
- VARCHAR(25),
- DATEADD(
- DD,
- -(
- DAY(
- DATEADD(MM, 1, @TODAY_DATE)
- ) -1
- ),
- DATEADD(mm, 1, @TODAY_DATE)
- ),
- 103
- ) AS DATE_NAME,
- 'FIRST DATE OF NEXT MONTH'
- UNION ALL
- SELECT
- CONVERT(
- VARCHAR(25),
- DATEADD(
- DD,
- -(
- DAY(
- DATEADD(MM, 1, @TODAY_DATE)
- )
- ),
- DATEADD(mm, 1, @TODAY_DATE)
- ),
- 103
- ) AS DATE_NAME,
- 'LAST DATE OF CURRENT MONTH' GO