klinmy Posted March 18, 2006 Share Posted March 18, 2006 i'm doing a form which the admin can enter a particular date for the system's users. Different users may have different dates which will be deducted by the current date in order to get the duration.my question is, can i make a button which can update all the duration of the system's users in the database, so that the admin doesn't need to update the duration one by one when it enters a new year?thanks Quote Link to comment Share on other sites More sharing options...
AV1611 Posted March 18, 2006 Share Posted March 18, 2006 I don't really understand your question, but if you want to go into the database and select all records, or a group a records, and adjust a date? by the same amount, or be a formula, then yes... you can do that. Quote Link to comment Share on other sites More sharing options...
Barand Posted March 19, 2006 Share Posted March 19, 2006 As AV1611 said, yes you can, but why bother? The durations can be calculated when required so no need to store such derivable data in the DB. By tomorrow they are going to be out of date. Quote Link to comment Share on other sites More sharing options...
klinmy Posted March 19, 2006 Author Share Posted March 19, 2006 thanks alot.. i will try todo tht.i need the duration, coz it involves in another calculation in other forms Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.