topic RE: Format Date not working for format (09-06-2023) in Product Forum

Format Date not working for format (09-06-2023)

Soumya21 — Fri, 09 Jun 2023 06:02:00 GMT

Hi,

When we are formatting date from 09-06-2023 to 09/06/2023 using calculation stage

I am not getting required format instead its showing old format

Can anyone please help on this.

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Format Date not working for format (09-06-2023)

Athiban_Mahamathi — Fri, 09 Jun 2023 06:40:00 GMT

Hi soumya,

Looks like you are trying to apply date formatting to a text data item. Please convert the data type to date and try the formatting. Refer below.

FormatDate(ToDate([D]), "dd/MM/yyyy")

------------------------------
Athiban Mahamathi ,
SimplifyNext,
Technical Consultant
------------------------------

RE: Format Date not working for format (09-06-2023)

Soumya21 — Fri, 09 Jun 2023 07:03:00 GMT

dataitem d is in date format

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Format Date not working for format (09-06-2023)

Athiban_Mahamathi — Fri, 09 Jun 2023 07:13:00 GMT

can you please share the data item screenshot.

------------------------------
Athiban Mahamathi ,
SimplifyNext,
Technical Consultant
------------------------------

RE: Format Date not working for format (09-06-2023)

Soumya21 — Fri, 09 Jun 2023 08:47:00 GMT

PFA Screenshot

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Format Date not working for format (09-06-2023)

Athiban_Mahamathi — Fri, 09 Jun 2023 09:13:00 GMT

Interesting!!! Your BP shows that by default the date is stored as "dd-MM-yyyy". I guess in the calc stage you are trying to store the formatted date to the same variable [d]. Hence the date is stored to the default format though you had applied the formatting. In your case, please try to store the formatted date to a text data item in the calc stage. Refer below.

I can see that my BP sandbox has the default date format as "dd/MM/yyyy". May I know your BP version? Mine is 7.1.2.

------------------------------
Athiban Mahamathi ,
SimplifyNext,
Technical Consultant
------------------------------

RE: Format Date not working for format (09-06-2023)

Kishore_KumarDe — Fri, 09 Jun 2023 09:15:00 GMT

Hi Soumya,

You are not getting the forward slashes(/) because of the Date format of your windows system. I know it is a weird behavior of Blueprism but if Windows date setting have forward slashes then you will get that otherwise it shows "-". As a work around you can use a string replace function as below.

I just replaced spaces with "/"

Try that and see if that works for you.

------------------------------
If my answer provided any assistance, please vote as "Best Answer".

Kishore Deka
Lead Software Engineer
EPAM systems

Connect on LinkedIn
https://www.linkedin.com/in/kishoredeka1410/
------------------------------

RE: Format Date not working for format (09-06-2023)

Sheela — Fri, 09 Jun 2023 09:17:00 GMT

Which version of Blueprism are you using?

------------------------------
Sheela Parthasarathy
Assistant Vice President
Deutsche Bank Group
Pacific/Apia
------------------------------

RE: Format Date not working for format (09-06-2023)

michaeloneil — Fri, 09 Jun 2023 10:57:00 GMT

Hi @Soumya K

The data items, if set as a date, will default to your system date format meaning after you run the calculation the date in the data item remains the same format. If you change the data item to a text then the calculation format will work and output correctly or use a separate data item to output the formatted date to but this would need to be text item.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Format Date not working for format (09-06-2023)

Soumya21 — Fri, 09 Jun 2023 11:05:00 GMT

Hi,

Yes, we can do like this also, Thank you for response

It was working before now it's not reflecting now when we use in formatDate

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Format Date not working for format (09-06-2023)

Kishore_KumarDe — Fri, 09 Jun 2023 11:28:00 GMT

You are welcome. It is because of your system date format on which you are running.