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

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

SANDEEPRATTAN — Thu, 01 Apr 2021 21:03:00 GMT

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

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

Tejaskumar_Darji — Fri, 02 Apr 2021 13:51:00 GMT

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

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

SANDEEPRATTAN — Mon, 05 Apr 2021 01:30:00 GMT

thanks

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