Expert: Concise Systems/Laird Scranton - 5/19/2006

Question
In order to effectively audit user accounts created over a period of time I need to locate the date the account was created.  The administrators are unaware of a field or the process to identify when the user account was created and generate such a list.  What are the commands and fields required to generate such a report/list for user accounts.

Thank you,

Answer
The person who designed the file may or may not have included a field to record the date the account was opened. If such a field exists, retrieving it should be very easy. If not, a programmer may be able to approximate it by retrieving the date of the first historical transaction for the account. A good programmer should be able to accomplish this in an hour or less.

- Laird