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