cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove timestamp from the date value?

NehaGote
Level 4
Hi,
 I have a date value in the following format 10-11-2021 03:00:00 . I want to remove timestamp from it want something that looks like 10-11-2021. Does anyone know how can it be achieved ?

------------------------------
Neha Gote
------------------------------
6 REPLIES 6

EmersonF
MVP
I believe you can use this function FormatDateTime ([Hora Local], "dd-MM-yyyy"), I believe that will work!!

Edit---------------------------------------------------------
27249.png

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------
Sr Cons at Avanade Brazil

ritansh.jatwani
Level 9
Hi @NehaGote,

As mentioned by @EmersonF, it is one of the ways to convert the datetime format to date format. Also, you can use casting feature of Blueprism where store the input datetime in a variable and then using calculation stage, just store that output value in a date variable type. PFB the screenshot for the same:

27254.png​​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

Hey, I like this one!! I had never used it like this

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------
Sr Cons at Avanade Brazil

Thanks @EmersonF
Happy to share the info​ 🙂
You can try this one

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

Hi Emerson it worked thanks 🙂

------------------------------
Neha Gote
------------------------------

Hi Ritansh , Thats a cool feature I agree with Emerson never used it before. It worked thanks 🙂

------------------------------
Neha Gote
------------------------------