How to convert LocalTime() to 24 hr format as hh:mm:ss ?

[Tejaskumar_Darji]

How to convert LocalTime() to 24 hr format as hh:mm:ss ?

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

[ewilson]

Hi @Tejaskumar_Darji,

I don't think the FormatDateTime() function will accept the output of LocalTime() directly, so you'll probably need to write it to a Text data item. Then you can pass it in to FormatDateTime() with the format "HH:mm" as shown below:

​FormatDateTime([Local Time], "HH:mm:ss")

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[EmersonF]

Trying to contribute and enrich this post, if the date comes from an SQL query in the query itself you can put Format([Column Name], "hh:mm:ss"), but if it's an expression of blue prism what the @ Eric Wilson said it will work for you​

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
PAULISTA
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[JohnCowell]

Although not strictly related, just to add something else to the pot, take a look at the Utility - Data and Time Manipulation VBO to see if any of those actions may be of use. 'UTC To Local' has come in very handy on several occasions. 

------------------------------
John Cowell
Senior Software Support Analyst
Blue Prism
------------------------------

[UAMudrykIh]

You can try this expression:

FormatDateTime(Now()+(LocalTime()-UTCTime()), "HH:mm:ss")

[stepher]

Good morning, All,  (and this is pertinent in a second).

I feel like I am missing something here, but I believe the following will get you what you are looking for:

FormatDateTime(Today() & " " & LocalTime(), "HH:mm:ss")

It is too early in the morning for the 24-hour indication to trigger, but the time value is valid.

As I said, it is entirely possible that I am not fully awake yet.

Enjoy,

Red