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 it like: No, 2022-5-12

 

How??

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

     

     

2 Replies

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

     

     

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    Can you try 

    Result = DATEVALUE([Test])

     

    Also there are formatting options on top ribbon:

    I hope this helps..