Cenny Active Member Licensed User Longtime User Jan 16, 2017 #1 Hi, I have an Access database file where date data is saved in the format 'dd-mm-yyyy'. How can I import these dates in sqlite so that they can be correctly sorted? Thanks for your help Cenny
Hi, I have an Access database file where date data is saved in the format 'dd-mm-yyyy'. How can I import these dates in sqlite so that they can be correctly sorted? Thanks for your help Cenny
Ohanian Active Member Licensed User Longtime User Jan 16, 2017 #2 Hi, Convert date field into Unix time format (long) and store them. Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Jan 16, 2017 #3 Parse the dates in your B4A code and store the ticks values. Upvote 0
Cenny Active Member Licensed User Longtime User Jan 17, 2017 #4 Ohanian said: Hi, Convert date field into Unix time format (long) and store them. Click to expand... Thanks for the help. Cenny Upvote 0
Ohanian said: Hi, Convert date field into Unix time format (long) and store them. Click to expand... Thanks for the help. Cenny
Cenny Active Member Licensed User Longtime User Jan 17, 2017 #5 Erel said: Parse the dates in your B4A code and store the ticks values. Click to expand... Thanks for the help. Cenny Upvote 0
Erel said: Parse the dates in your B4A code and store the ticks values. Click to expand... Thanks for the help. Cenny