Blue Prism University

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

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

Original Message:
Sent: 04-01-2021 22:02
From: SANDEEP RATTAN
Subject: Returning date text in format 2021-04-01 from 4/01/21

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

thanks

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

Original Message:
Sent: 04-02-2021 14:50
From: Tejaskumar Darji
Subject: Returning date text in format 2021-04-01 from 4/01/21

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

Original Message:
Sent: 04-01-2021 22:02
From: SANDEEP RATTAN
Subject: Returning date text in format 2021-04-01 from 4/01/21

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