Days Between Dates
|
| Posted: 11/24/2004, 12:39 PM |
|
This is my situation; I have a table(strorage) with the following fields
OrderID
Order_Date
Drop_Date
Pick_UP_Date
I need to see how many days between Drop_Date and Pick_Up_Date. But Pick_Up_Date will not be filled in until the day we pick it up, so I want a running total of days until current date, until a value is inserted into Pick_Up_Date. Once that is filled in; I want to show just the days between those dates. But until I insert value; show how many days running.
What happened is I drop a trailer on Drop_Date and then 30, 60, 90, Etc... Days later they call me to come pick it up. Once I do that I insert Pick_Up_Date, but when I look at the current manifest I want to see how many days it has been Dropped for. But as soon as I put in a Pick_Up_Date i need that to tell me how many days it was there.
Help is very much appreciated, Thanks
Using .ASP
|
|
|
 |
kevind
Posts: 251
|
| Posted: 11/26/2004, 2:45 AM |
|
If this is being presented in a data Grid then I assume you have some columns like column 'Days Since Drop' and 'Total Storage Days'.
In the Before Show Row event for the grid you can test for the Drop_Date field being null and then hide the labels that represent the 2 columns by simply setting the value of the column label you want to hide to:
MyColumnLabel.value=""
Let me know if that helps.
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
|
|
