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

  800 Points

  201 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

  52373 Points

  15607 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

  40485 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

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