Android Question Set date from and to

Welcolm to b4A ...One approach would be 2 labels with text 'From .. ' & 'To ...' with a click event to display AnotherDatePicker .. (see above Similar threads).
This might also work with Date Dialogue ,but having never used it I cant comment.
A Flag variable would determine which label is updated.
you would have to do some date checks to validate correct date choices / spread.

mangojack said:

Welcolm to b4A ...One approach would be 2 labels with text 'From .. ' & 'To ...' with a click event to display AnotherDatePicker .. (see above Similar threads).
This might also work with Date Dialogue ,but having never used it I cant comment.
A Flag variable would determine which label is updated.
you would have to do some date checks to validate correct date choices / spread.

Click to expand...

Hi:

If you're using a database like MySQL or SQLite, you can use SQL sentences, some like :

"SELECT ...... FROM database WHERE database.date > 'YYYY-mm-dd' OR database.date <'YYYY-mm-dd' "

This one queries the database to retrieve only the stated registers where the date is between the dates.

For the exact SQL syntax, query google or the b4a forum


Hope this helps ...

Barry ... was doing nothing and wanted to learn a bit about AnotherDatePicker.
this is a basic display that allows user to choose 2 dates .. which can then be used for your SQL select statements.
at present the only check that is done is that the second date is Not older than the first date.
obviously other checks would have to be performed.

You might find it useful.

p.s. the selected dates are stored as Long so you would have to format to suite your SQL date data.

Thank you master's i will try all of ur ideas.