Subtract Year [Answered]RSS

• • Reply
  JagjitSingh

  Member

  503 Points

  1769 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

  Member

  710 Points

  172 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

  52182 Points

  15489 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

  39066 Points

  5664 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

  
  MSDN Community Support
  Please remember to "Mark as Answer" the responses that resolved your issue.