Tom
|
| Posted: 03/05/2002, 2:39 AM |
|
Message I have a problem in designing a page, in which, I want to reterive the Date of the First Record insert by a user (who logged in) in the message database like this forum(each inserted record has a field UserID and Date of Inserting record), and show on the form that "YOU ARE .... DAYS OLD USER OF THE FORUM".
There are many message posted in the messagebox (forum) during previous days by many users and they are saved in the same database table.
How I trace the date when first record was posted by the person who logged-in? and display the above message on the form.
Please Help me.
Tom
|
|
|
 |
Nicole
|
| Posted: 03/05/2002, 7:13 AM |
|
Tom,
Date handling issue depends on db and language you use. Could you provide such information?
Common approach is to select min date value for logged in user and compare it with current date in order to get difference in days.
|
|
|
|
Tom
|
| Posted: 03/05/2002, 9:13 PM |
|
Dear Sir,
Thanks for reply. This is my mistake.
I am using MsAccess 2000 DB.
One Thing I also want to mention here : I want to calculate days from the first record (Message) sent in the forum by the user (Not the Sign-in date to forum).
Please Help Me.
|
|
|
|
|
