topic RE: How to write 20220915 as 2022/09/15 in Product Forum

How to write 20220915 as 2022/09/15

HelariaShaningw — Thu, 15 Sep 2022 13:04:00 GMT

Good day

Can you please help me out as i am new to blue prism.
How can i write this data item value "20201015" as 2020/10/15?. This value i am getting it from a business object as it is by using a read stage. I tried using split text and extract regex values but no difference.

This value "20221015" is read and stored in the data Item as Text.
FomatDate did also not work.

------------------------------
Helaria Shaningwa
RPA Intern
------------------------------

RE: How to write 20220915 as 2022/09/15

ShuaibSalie — Thu, 15 Sep 2022 14:12:00 GMT

Hi Helaria,

Here's a way of achieving what you want, hopefully it can help you.
So first we need a way to extract the day, month and year from your text data item:

Right([Data1], 2) - We are extracting the day here
Left([Data1], 4) - We are extracting the year
Mid([Data1], 5, 2) - We are extracting the month

Then we need to make it a date:

MakeDate(Right([Data1], 2), Mid([Data1], 5, 2), Left([Data1], 4))

Then lastly we put it all together and format the date (The below expression is what you'll use in your calc stage):

FormatDate(MakeDate(Right([Data1], 2), Mid([Data1], 5, 2), Left([Data1], 4)), "yyyy/MM/dd")

There might be simpler ways of achieving this.

I hope it helps you
Thank you

------------------------------
Shuaib Salie

------------------------------

RE: How to write 20220915 as 2022/09/15

ManpreetKaur1 — Thu, 15 Sep 2022 18:46:00 GMT

Hi @Helaria Shaningwa,

You can

For finding year:

For finding Date:

For finding month, since we know that it will always be after 4th character and its format is MM (2 characters) hence:

For performing final calculation:

Please let me know if it doesn't work for you.

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

RE: How to write 20220915 as 2022/09/15

HelariaShaningw — Fri, 16 Sep 2022 12:52:00 GMT

Hi Manpreet Kaur

It is working perfectly.
Thank you very much.

------------------------------
Helaria Shaningwa
------------------------------

RE: How to write 20220915 as 2022/09/15

HelariaShaningw — Fri, 16 Sep 2022 12:53:00 GMT

Hi Shuaib Salie

Issue is resolved, thanks very much for your input.
Much appreciated.

------------------------------
Helaria Shaningwa
------------------------------

RE: How to write 20220915 as 2022/09/15

ManpreetKaur1 — Fri, 16 Sep 2022 14:09:00 GMT

Hi @Helaria Shaningwa,

Glad to hear it worked :)

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------