topic RE: How to remove timestamp from the date value? in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68115#M20720 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/16121">@NehaGote</a>,<BR /><BR />As mentioned by <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/1854">@EmersonF</a>, 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:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="27254.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/27381i75497A8CBEF4195A/image-size/large?v=v2&amp;px=999" role="button" title="27254.png" alt="27254.png" /></span>​​<BR /><BR />------------------------------<BR />Ritansh Jatwani Senior Consultant<BR />Consultant<BR />EY<BR />Gurgaon<BR />*If you find this post helpful mark it as best answer<BR />------------------------------<BR /> Mon, 25 Oct 2021 19:35:00 GMT ritansh.jatwani 2021-10-25T19:35:00Z How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68113#M20718 Hi,<BR />&nbsp;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 ?<BR /><BR />------------------------------<BR />Neha Gote<BR />------------------------------<BR /> Mon, 25 Oct 2021 15:52:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68113#M20718 NehaGote 2021-10-25T15:52:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68114#M20719 I believe you can use this function FormatDateTime ([Hora Local], "dd-MM-yyyy"), I believe that will work!!<BR /><BR />Edit---------------------------------------------------------<BR /><span class="lia-inline-image-display-wrapper" image-alt="27249.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/27380i95558861CF111DCA/image-size/large?v=v2&amp;px=999" role="button" title="27249.png" alt="27249.png" /></span><BR /><BR />------------------------------<BR />Emerson Ferreira<BR />Sr Business Analyst<BR />Avanade Brasil<BR />Recife<BR />+5581988869544<BR />If my answer helped you? Mark as useful!<BR />------------------------------ Mon, 25 Oct 2021 16:38:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68114#M20719 EmersonF 2021-10-25T16:38:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68115#M20720 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/16121">@NehaGote</a>,<BR /><BR />As mentioned by <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/1854">@EmersonF</a>, 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:<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="27254.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/27381i75497A8CBEF4195A/image-size/large?v=v2&amp;px=999" role="button" title="27254.png" alt="27254.png" /></span>​​<BR /><BR />------------------------------<BR />Ritansh Jatwani Senior Consultant<BR />Consultant<BR />EY<BR />Gurgaon<BR />*If you find this post helpful mark it as best answer<BR />------------------------------<BR /> Mon, 25 Oct 2021 19:35:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68115#M20720 ritansh.jatwani 2021-10-25T19:35:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68116#M20721 Hey, I like this one!! I had never used it like this<BR /><BR />------------------------------<BR />Emerson Ferreira<BR />Sr Business Analyst<BR />Avanade Brasil<BR />Recife<BR />+5581988869544<BR />If my answer helped you? Mark as useful!<BR />------------------------------<BR /> Mon, 25 Oct 2021 20:13:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68116#M20721 EmersonF 2021-10-25T20:13:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68117#M20722 Thanks <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/1854">@EmersonF</a>.&nbsp;<BR />Happy to share the info​ <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />You can try this one<BR /><BR />------------------------------<BR />Ritansh Jatwani Senior Consultant<BR />Consultant<BR />EY<BR />Gurgaon<BR />*If you find this post helpful mark it as best answer<BR />------------------------------<BR /> Mon, 25 Oct 2021 20:15:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68117#M20722 ritansh.jatwani 2021-10-25T20:15:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68118#M20723 Hi Emerson it worked thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />------------------------------<BR />Neha Gote<BR />------------------------------<BR /> Tue, 26 Oct 2021 09:06:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68118#M20723 NehaGote 2021-10-26T09:06:00Z RE: How to remove timestamp from the date value? https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68119#M20724 <SPAN>Hi Ritansh , Thats a cool feature I agree with Emerson never used it before. It worked thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><BR />------------------------------<BR />Neha Gote<BR />------------------------------<BR /> Tue, 26 Oct 2021 09:07:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-timestamp-from-the-date-value/m-p/68119#M20724 NehaGote 2021-10-26T09:07:00Z