Skip to main content
kavyam0002
kavyam0002
August 3, 2021
Question

How to give 2/more years while checking condition

  • August 3, 2021
  • 13 replies
  • 0 views

if(ri!vfm_lastupdate<today()+730,"new",
if(or((ri!vfm_lastupdate > today()+731),(ri!vfm_lastupdate>=today()+1440)), "refurbished",
if(ri!vfm_lastupdate>today()+1828,"Testing Required","Null")))

here i need to check if the given date is less than 2 years compared to present date then show new, else between 2-5 display refurbished else more than 5 years display testing required 

    13 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 3, 2021

    OK. And what is the result you see? The "or" in the second line looks suspicious.

    kavyam0002
    kavyam0002Author
    August 3, 2021

    in the above condition am adding number of days but instead i want to give no of years and check directly. in the or condition am checking between 2-5 years 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 3, 2021

    One option: edate(today(), 24) will add 24 months.

    What do you mean with "check directly"

    stewart.burchell
    stewart.burchell
    August 3, 2021

    It's usually easier to structure these things by ordering them in reverse order...test whether the value is > 2years first, then, if not, test the value is > than 1 year, then otherwise the value must be < 1 year.

    Your requirement is:

    Date < 2 years : condition will be "New" ,Date > 2years & date <5years - condition will be "refurbished", Date >5 years condition = "require testing" 

    So let's test if > 5 years first, then > 2 years second, otherwise it must be < 2 years.

    kavyam0002
    kavyam0002Author
    August 3, 2021

    that's what how to give 2 years as in condition 

    stewart.burchell
    stewart.burchell
    August 3, 2021

    This is how I would structure it:

    if(
  ri!vfm_lastupdate>today()+1825,"Testing Required",
  if(
    ri!vfm_lastupdate>today()+730,"Refurbished",
    "New"
  )
)

    You may disagree about the actual values (I've used 5 years as 365*5, but you may want to throw in a leap year value)...same as the value for 2 years (I've used 365*2) but the principle is the same.

      aparajitas0001
      aparajitas0001
      August 3, 2021

      is the last updated date supposed to be compared with 2 years in future or two years older? According to the requirement I feel the requirement is to check in the past.

      kavyam0002
      kavyam0002Author
      August 4, 2021

      if(
      ri!vfm_lastupdate > today() - 730,
      "new",
      if(
      (
      ri!vfm_lastupdate < today() - 731
      ),
      if(
      ri!vfm_lastupdate > today() - 1826,
      "testing required",
      if(
      ri!vfm_lastupdate > today() - 1827,
      "refurbished",
      "null"
      )
      ),
      "Null"
      )
      )

      Terms & ConditionsAccessibility statement