topic Change date/time format from CET to US (with AM/PM) format in Product Forum

Change date/time format from CET to US (with AM/PM) format

TomJansen — Wed, 04 Mar 2020 08:58:00 GMT

Hi there,

I have been dealing with some trouble some web user interface which I can't find a proper solution with.
I'm working in NL, and are using some internal websites, which are created by our US partner.

At the end of the form, you have to give the current date and time in us formating.

03/04/2020 2:03 PM.

So in NL the standard formating would be 4-3-2020 14:03

I have tried working with Utility - Date and Time manipulation but I just does not seem to work.

Does anybody have an idea how to do this change in formatting?

Thank you for the help!

------------------------------
Tom Jansen
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Wed, 04 Mar 2020 12:22:00 GMT

Did you try format date? Format date( today(),"M-d-yy")

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Wed, 04 Mar 2020 12:33:00 GMT

Here is the screenshot. Let me know if this works for you.

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

TomJansen — Wed, 04 Mar 2020 13:25:00 GMT

Hi Swetha,

thank you for helping me out. But this is not working for me. Maybe my help question was not clear. The expression result you suggest is the same as that I have.
But I need to transfor this formatting to the US formatting.

So basicly, how can I transfor the format: 4-3-2020 14:03 -> 3/4/2020 2:03 PM

Kind regards
Tom

------------------------------
Tom Jansen
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Wed, 04 Mar 2020 16:05:00 GMT

Hi Tom,

Is this the way you wanted?

Please let me know.

Thanks

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

TomJansen — Thu, 05 Mar 2020 08:57:00 GMT

Hi Swetha,

yes that is exactly what I want. I formatted it the same as that you did. But I still get the same expression result back.

------------------------------
Tom Jansen
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Thu, 05 Mar 2020 09:56:00 GMT

Hi Tom,

How is your system date formatted as? Mine is as below. Can you check and update yours if it is not in the same format and try again to see if it works? Let me know.

Thanks.

Regards,

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

TomJansen — Thu, 05 Mar 2020 11:52:00 GMT

Hi Swetha,

I checked the system time (local) on my laptop (windows7), changed format to English (United States). On my laptop it now shows the US formatting. But for Blue Prism, this does not help/work. It still remains the same outcome. Can't change anything further within Blue Prism itself, as this is only for admins.

------------------------------
Tom Jansen
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Thu, 05 Mar 2020 18:56:00 GMT

Hi Tom.

Right, you may need to contact the admin, I am not sure how we can update the format in blueprism. When I change the system date format, still the expression is evaluating fine on my machine. Now am eager to know how this can be fixed.

Thanks,

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

GopalBhaire — Fri, 06 Mar 2020 06:13:00 GMT

Can you check result with Utility Date Time Manipulation -> Format Date because I can see that FormatDateTime is not working in one of your screenshot as it shows (-) in result when you have specified (/) in expression.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Change date/time format from CET to US (with AM/PM) format

Swetha__Devaram — Fri, 06 Mar 2020 17:58:00 GMT

As Gopal mentioned, I tried it and it worked for me. Thanks Gopal.

------------------------------
Swetha Devaram
RPA Developer
Health Markets
America/Chicago
------------------------------