Last post Nov 05, 2018 06:06 AM by Fei Han - MSFT
Member
504 Points
1776 Posts
Nov 03, 2018 05:33 PM|JagjitSingh|LINK
Hi
How to subtract a year from below code
SET @m_date0 = DATEFROMPARTS(@Year, 4, 1)
Thanks
Participant
1120 Points
292 Posts
Nov 03, 2018 06:12 PM|imapsp|LINK
Hi,
Try:
SET @m_date0 = DATEADD(YEAR, -1, DATEFROMPARTS(@Year, 4, 1))
Hope this help
All-Star
52523 Points
15674 Posts
Nov 04, 2018 04:26 AM|oned_gk|LINK
Date and Time Data Types and Functions (Transact-SQL)
40535 Points
6233 Posts
Microsoft
Nov 05, 2018 06:06 AM|Fei Han - MSFT|LINK
Hi JagjitSingh,
JagjitSingh How to subtract a year from below code SET @m_date0 = DATEFROMPARTS(@Year, 4, 1)
In your code, we can find that you define and pass year via variable @Year, to subtract a year from it, you can use:
--YOUR CODE LOGIC SET @Year = CONVERT(int, @Year) - 1; SET @m_date0 = DATEFROMPARTS(@Year, 4, 1)
Besides, as others mentioned, some functions that could also help modify Date, such as DATEADD(datepart,number,date).
With Regards,
Fei Han
Member
504 Points
1776 Posts
Subtract Year
Nov 03, 2018 05:33 PM|JagjitSingh|LINK
Hi
How to subtract a year from below code
SET @m_date0 = DATEFROMPARTS(@Year, 4, 1)
Thanks
Participant
1120 Points
292 Posts
Re: Subtract Year
Nov 03, 2018 06:12 PM|imapsp|LINK
Hi,
Try:
Hope this help
All-Star
52523 Points
15674 Posts
Re: Subtract Year
Nov 04, 2018 04:26 AM|oned_gk|LINK
Date and Time Data Types and Functions (Transact-SQL)
Suwandi - Non Graduate Programmer
All-Star
40535 Points
6233 Posts
Microsoft
Re: Subtract Year
Nov 05, 2018 06:06 AM|Fei Han - MSFT|LINK
Hi JagjitSingh,
In your code, we can find that you define and pass year via variable @Year, to subtract a year from it, you can use:
Besides, as others mentioned, some functions that could also help modify Date, such as DATEADD(datepart,number,date).
With Regards,
Fei Han