Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

concatenate string and year

Hi,  Please i need your help ,  I want to create a new column with this statement :  NewVintage = Var test= CONCATENATE("<",VALUE(YEAR(TODAY()) - 4)) // <2019   return IF( Investee[LegalVinta...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , I think data type issue

     

    trye like

     

    NewVintage =
    Var test= CONCATENATE("<",VALUE(YEAR(TODAY()) - 4)) // <2019

    return IF( Investee[LegalVintage] < YEAR(TODAY())- 4
    , test

    , Investee[LegalVintage] & ""
    )

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , I think data type issue

 

trye like

 

NewVintage =
Var test= CONCATENATE("<",VALUE(YEAR(TODAY()) - 4)) // <2019

return IF( Investee[LegalVintage] < YEAR(TODAY())- 4
, test

, Investee[LegalVintage] & ""
)