topic Re: Split Date from Datetime value in Product Forum

Split Date from Datetime value

RohanGoswami1 — Mon, 02 Jan 2023 13:07:26 GMT

hi I need little help in splitting the date from datetime value. Previously I was doing like this
Datetime = 19/09/2022 17:44:17
date = left(Datetime, 10) = 19/09/2022

Now this is not working as
Datetime = 1/2/2023 17:44:17
date = left(Datetime, 10) = 1/2/2023 1

Any efficient way to do this manipulation?

Re: Split Date from Datetime value

Denis__Dennehy — Mon, 02 Jan 2023 14:02:09 GMT

Hello Rohan. What you want is to use the FormatDate function. Another thread on this forum has the answer to what you want: How to convert date format (dd/mm/yyyy) to (mm/dd/yyyy) | Blue Prism Product

The calculation UI has great help for building functions, I suggest maybe spending time looking at all the functions available under 'Date' as the answer was there for you to discover. There is also good help in the Blue Prism online help for Calculations and Decisions.

Re: Split Date from Datetime value

MichealCharron — Mon, 02 Jan 2023 16:06:34 GMT

If you are just trying to convert a DateTime value to a Date value, you can use the ToDate() function. The ToDate() function works both with DateTime data items and Text data items (as long as the string is in the proper DateTime format).

Re: Split Date from Datetime value

EslamGhandour — Mon, 02 Jan 2023 17:11:47 GMT

As Michael mentioned, using the ToDate() will be your way to go. However, one of the main things to consider working with that, is that it works according to the format of date on your pc. Which means if the time on your pc is mm/dd/yyyy and the value you path to that function is dd/mm/yyyy, it will not be providing you accurate values and it might be breaking when the mm value will be more than 12 as there are only 12 months. Work with that in mind and you'll be safe to go.

Re: Split Date from Datetime value

Prasanth_IRPA_Dev — Mon, 02 Jan 2023 18:55:13 GMT

Hi

You can use FormatDate, ToDate but the problem is Input Format => MM/dd/yyyy or else PFB you'll get this error

So you can try this, It's effective => Trim(Left("1/2/2023 17:44:17", InStr(Trim("1/2/2023 17:44:17"), " ")))

Re: Split Date from Datetime value

Soumya21 — Tue, 03 Jan 2023 04:22:59 GMT

Hi @RohanGoswami1

Check this expression will it work for you
Replace(Replace("1/2/2023 17:44:17",Right("1/2/2023 17:44:17",8),"")," ","")

Thanks,
Soumya

Re: Split Date from Datetime value

ÖzençGezgin — Tue, 03 Jan 2023 17:48:52 GMT

Yes. Very efficient way 🙂

Do not use any formula. Only use data item...
Expression section: [Datetime]
Store Result in section: date

Re: Split Date from Datetime value

ÖzençGezgin — Tue, 17 Jan 2023 13:32:42 GMT

Hi Rohan,

Did you try my solution?

Re: Split Date from Datetime value

RohanGoswami1 — Tue, 17 Jan 2023 13:39:33 GMT

For my requirements I am using the FormatDate and it working Fine. Thanks for all the responses, Appreciate it.