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[LegalVintage] < YEAR(TODAY())- 4
, test
 
, Investee[LegalVintage]
)
 
But i have the following error :

can you help me please ? 

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] & ""
    )

1 Reply

  • 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] & ""
    )