tulnetdotcom
Posts: 26
|
| Posted: 09/14/2004, 3:47 AM |
|
I have database for assets.
the fields are : srno, assetno. reporteddate, attendeddate, status
How do i get diff in days between reportdate and currentdate?
At the same time it should update the field status.
Thanks
|
 |
 |
marcwolf
Posts: 361
|
| Posted: 09/14/2004, 4:56 PM |
|
What database are you using.
There are a number of ways to do this and several DB engines have built in Date calulation routines.
Alternatively - you can use pure ASP/VBScript and perform a DateDiff on the two values, and depending on the result update the Field Status
Hope this helps.
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
|
