Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Tuesday, March 21, 2023 
View User Profile  

 User Profile - Stuart  
OAG Worldwide

IT Development, OAG Worldwide, Dunstable, UK

Log in to send this member a message!

 Stuart's Contributions
Stuart has contributed 2 comments and 0 articles.
Select to view:    
Comment: Re: E1 User Audit
Whilst this is an excellent tool, I have one small problem. It seems some users (not all, and I can't see the pattern) have their date and month of last login stored the wrong way round. And I think it happens on the 11th and 12th of the month.

We have GB date settings, and today (12 Jun 2007) we have three users logged as 06 Dec 2007 and all the others as 12 Jun 2007.
Anyone else seen this?

I have looked at the code that fires at login and it just sets the date like this:

Login(5) = cstr(now)

And in the debugger that looks like this:

? login(5)
12/06/2007 11:34:21

But the Field is like this:

? oRS.Fields("Login5")
06/12/2007 11:34:21

In query analyzer the dates look like this:

FROM sysdba.E1_AUDIT

2007-12-06 10:32:06.000
2007-11-06 11:04:27.000
2007-12-06 09:56:53.000
2007-12-06 09:52:35.000

(4 row(s) affected)

Author: Stuart - 6/12/2007

Comment: Re: E1 User Audit
This is a great utility, thanks Mike.

Author: Stuart - 7/26/2006


 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2023 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 3/21/2023 9:38:36 PM