Blue Prism University

 View Only
last person joined: 15 hours ago 

A Community to discuss and learn more about Blue Prism University and certification. Please use the Product communities for specific technical queries.

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

    Posted 04-01-2021 22:03
    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
    ------------------------------


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

    Posted 04-02-2021 14:51
    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
    ------------------------------



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

    Posted 04-05-2021 02:30
    thanks

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



Welcome to the Blue Prism University Community

This is a space for our users to discuss and learn more about Blue Prism University and certifications. Click the "Join" button above to be alerted to new activity and events happening in this community!

This is not the appropriate place for product questions. Do you have questions about the Blue Prism RPA Product, Decipher, Digital Exchange, or another Blue Prism offering? Check out our list of Tech Chat Communities to find the right place for your discussion.

Foundation TrainingComplete Our SurveyBook an Exam