Forum Discussion

Bergh's avatar
Bergh
Icon for Helper II rankHelper II
4 years ago
Solved

Date format in text column

Hi. I have this one: Test = CONCATENATE(related(apdv035_ppap_dim[_Exist_PPAP]), ", "& (RELATED(apdv302_part_period_dim[ea_minus_40]))) The column is text. The output is: No, 12/5/2022  But I want...
Date
Format
  • Arul's avatar
    Arul
    4 years ago

    Bergh ,

    try this

     

    Test = CONCATENATE(related(apdv035_ppap_dim[_Exist_PPAP]), ", "& (format(RELATED(apdv302_part_period_dim[ea_minus_40]),"YYYY-M-D")))

     

     

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

Bergh ,

try this

 

Test = CONCATENATE(related(apdv035_ppap_dim[_Exist_PPAP]), ", "& (format(RELATED(apdv302_part_period_dim[ea_minus_40]),"YYYY-M-D")))