Date format in text column

[Bergh]

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??

[Whitewater100]

Hi:

Can you try 

Result = DATEVALUE([Test])

Also there are formatting options on top ribbon:

I hope this helps..

[Arul · Accepted solution]

@Bergh ,

try this

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