I do not know about database, I'm using one in Visual Studio (the default SQL called "Services-based Database"), I already integrated it into the form and made up the query fields.
But it has a field of one of the tables that would be dated, that date is like a 'loan', and it expires (in a week, as an example).
So here comes the doubt (I researched and did not find anything about it).
The question is:
How do I sort a table of this database by the data
field, showing the records of the data
field oldest to the newest?
Another doubt (this is more advanced), but the first one is enough for me (I'm humble kk), it's like, this data
field, as I said, is like a loan, so I wanted to know, taking the example registration:
"Nome: José", "Data do empréstimo: 23/06/2015"
In this table, as I've estimated the expiration date is a week, the expiration would be today, so how do I get that record from the database and store it in a variable (to be displayed in another form)?
The other field:
"Nome: João", "Data do empréstimo: 24/06/2015"
The maturity would be tomorrow, so tomorrow he would send that record to the other form automatically, as if it were a due notification.