uzeren

New member
Joined
Oct 3, 2022
Messages
1
Programming Experience
1-3
Hello, I'm doing a windows form project, in this project, when I subtract the entry date from the end date, I reflect the result to a column named remaining usage. What I want in the database is that this remaining usage decreases by 1 every 24 hours
 
Why would the number reduce by every 24 hours of the difference between entry date and end date does not change?
 
You don't really need to do anything once you have declared an end date; the advance of time does the decrement for you

Today: Monday Noon
Expiry Date: Friday Noon
Days Left: 4.0

Wait some..

Today: Tuesday Noon
Expiry Date: Friday Noon
Days Left: 3

Just do the days diff calc every time you want to know the remaining usage
 
Ah so Entry Date is not actually a fixed date, but rather meant to be the current date...
 
Back
Top Bottom