cancel
Showing results for 
Search instead for 
Did you mean: 

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

TomJansen
Level 2
​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
------------------------------
10 REPLIES 10

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

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

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

31153.png


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

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
------------------------------

Hi Tom,

Is this the way you wanted?
31155.png
Please let me know.

Thanks


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

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.
31159.png


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

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.

31166.png

31167.png
Thanks.

Regards,


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

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.
31175.png


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

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.

31185.png


Thanks,

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

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
------------------------------