en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Emilia  
#1 Posted : Friday, July 1, 2016 9:16:40 AM(UTC)
Emilia
Rank: Newbie

Groups: extranet\Forum
Joined: 4/6/2016(UTC)
Posts: 3

I've created a database that Targit logs the users moves.
But what I can see in ex. the "Targit Logging-brochures" is that Targit should log the time of usage too.

I highlited the time in the REQDATEUTC, as you can see, it's empty.
And what is the numbers in column REQTIMEUTC? It cannot be the time of the usage, this requests occured at approx. 10.50 and nog 08.23.

How can I make the time appear?

UserPostedImage
Ole Arp  
#2 Posted : Friday, July 1, 2016 12:44:41 PM(UTC)
Ole Arp
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/6/2011(UTC)
Posts: 41

Hi Emilia

The time registered that you see is UTC time. UTC time is used among other things to have the same starting point across the globe because it is without summer/winter time, so since we are in the same time zone, you would have UTC+2 which is 10.23.

There are two solutions. You can try to convert the UTC time to your local time or you can add two new fields to the table. REQDATE and REQTIME with the same data types as you have in the UTC fields. This solution will log your local time. The disadvantage for solution number two is that the fields will be left blank for the already logged transactions.
Med venlig hilsen / Best regards
Ole Arp

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.
Emilia  
#3 Posted : Friday, July 1, 2016 2:29:58 PM(UTC)
Emilia
Rank: Newbie

Groups: extranet\Forum
Joined: 4/6/2016(UTC)
Posts: 3

Thanks!

I'll try to make things work as I want :)
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error