Subtract Year[Answered] RSS

• • Reply
  JagjitSingh

  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

• • Reply
  imapsp

  Participant

  1120 Points

  292 Posts

  Re: Subtract Year

  Nov 03, 2018 06:12 PM|imapsp|LINK

  Hi,

  Try:

  SET @m_date0 = DATEADD(YEAR, -1, DATEFROMPARTS(@Year, 4, 1))

  Hope this help

  https://www.imoveisemexposicao.com.br/imoveis-venda-guarulhos-residencial-casa
• • Reply
  oned_gk

  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)

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  Fei Han - MS...

  All-Star

  40535 Points

  6233 Posts

  Microsoft

  Re: Subtract Year

  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

  .NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.