https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73087#M25692 Hi I am experiencing the same error where I cannot extract the seconds part of the LocalTime()   LocalTime() = 7:20:23 PM but if placed in a Data Item would result in 7:20 PM. Even the FormatDateTime cannot handle this. I even tried the Replace() text function but still not working. Thu, 25 Jan 2018 16:34:00 GMT CrisantoPaet 2018-01-25T16:34:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73083#M25688 Hi, can someone explain to me what are the differences between the functions Now() and LocalTime() and where the return values come from? I've set the right UTC Timezone in Windows, taskbar shows the right time, but now() returns one hour less, LocalTime() the same problem. (BP v5.018) Another Problem is Format DateTime in all Queries for object Work Queues. For example, i see in the log that an item is marked as completed at 07:01:20, if i call get completed items with calculated current time (for example 07:01:30) as EndTime i get no results. The problem is that the seconds are rounded off automatically or only full minutes are viewed. Here i see in the log that all items that are marked as completed are searched until 07:01:00. Is'nt it a bug? Please help. Thanks in advance. Thu, 02 Nov 2017 13:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73083#M25688 al2piwo 2017-11-02T13:48:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73084#M25689 Now() is a date time and LocalTime() is time only. Also the discrepancy in time might come from the time your server/DB is set to. Not uncommon for them to be set differently due to timezones. Fri, 03 Nov 2017 19:52:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73084#M25689 DexterWhelan1 2017-11-03T19:52:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73085#M25690 Now() gives back UTC time, LocalTime() gives back local time Mon, 06 Nov 2017 18:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73085#M25690 Graeme__Tacon 2017-11-06T18:00:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73086#M25691 Does Now() always return UTC time, irrespective of timezone set on the server/DB? Wed, 15 Nov 2017 18:31:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73086#M25691 MarcoWagner 2017-11-15T18:31:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73087#M25692 Hi I am experiencing the same error where I cannot extract the seconds part of the LocalTime()   LocalTime() = 7:20:23 PM but if placed in a Data Item would result in 7:20 PM. Even the FormatDateTime cannot handle this. I even tried the Replace() text function but still not working. Thu, 25 Jan 2018 16:34:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73087#M25692 CrisantoPaet 2018-01-25T16:34:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73088#M25693 Same issue here: LocalTime() results in 19:45 instead of 19:45:16, the part for seconds is missing. Why? Mon, 14 May 2018 22:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73088#M25693 ChristianLerch 2018-05-14T22:22:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73089#M25694 When LocalTime() result is stored in text in converts to HH:MM format. If you need Seconds also use Utility - Date and Time Manipulation VBO where you will find Get Time of Day Action. Keep ""Use UTC"" Parameter False and you will get current time with seconds.   Note: Data type of output result is Time Span, you can directly put Text Data type variable to get result into text     I hope this may help you. Tue, 15 May 2018 11:34:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73089#M25694 Hitesh__Mhatre 2018-05-15T11:34:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73090#M25695 This looks more like a bug. Seconds are required for calculations. So should be ideally available in LocalTime(). When LocalTime() is saved in a Time Variable, we get seconds. But not in other variable types. Wed, 17 Oct 2018 15:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73090#M25695 HustonLopes 2018-10-17T15:21:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73091#M25696 We also experience problems with LocalTime(). On some virtual clients, LocalTime() returns different time than clock (e.g. LocalTimer = 3 PM and clock = 6 PM). Any idea what could be the cause ? Fri, 14 Dec 2018 19:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73091#M25696 AlesKmunicek 2018-12-14T19:10:00Z https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73092#M25697 Hi Ales, Could you take a screenshot of that happened on one of the virtual clients? I've never seen that occur and I'd like to know for sure if that is possible. Respectfully, Dave Fri, 14 Dec 2018 20:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Difference-Now-LocalTime-DateTime-Queue/m-p/73092#M25697 david.l.morris 2018-12-14T20:29:00Z