Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
2 years ago
Solved

If Statement

Hi, can someone please help with the correct syntax below please?   I am trying to categorise the expected application end date by adding on 2.6 years to applicants from their app_in date.    If ...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello M_SBS_6 ,

     

    you can acheive what you want in the following measure

    App_end = if(app[age group] = "18-25", date(year(app[app_in])+2,

month(app[app_in])+5, day(app[app_in])))

     

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

M_SBS_6 

 

How much is 0.6 of a year?  Please provide an example of the result of adding 2.6 years to a date.

 

Phil