Returning date text in format 2021-04-01 from 4/01/21

[SANDEEPRATTAN]

Hi,

I am using this expression in calculation stage 
my data input is 4/01/21 in format month/dd/year 


"20"&Right([data16], 2) & "-" &Left([data16],2 )& "-" & Mid([data16], 3, 2)

but its returning 2021-4/-01 (Text) 

if i use 07/01/21 same m/d/y then i get below 
2021-07-/0 (Text) 


Please advice how I can fix this 

thanks
sandeep

------------------------------
SANDEEP RATTAN
------------------------------

[Tejaskumar_Darji]

Hello,

Use FormateDate function to achieve this task. Attaching expression. Tested and worked for both above scenario. Let me know if this helps and serve your purpose.

------------------------------
Thanks & Regards,
Tejaskumar Darji
------------------------------

[SANDEEPRATTAN]

thanks

------------------------------
SANDEEP RATTAN
------------------------------