Eme Fibonacci Well-Known Member Licensed User Longtime User Jul 4, 2016 #1 I have a table with birthdays in the format: mm-dd (no year) Examples: 02-31, 05-20, 12-31. I would like a sqlite query to calculate how many days are left until the next birthday. Even for the dates that are smaller than the present day. I did it in B4A code but was not elegant. I belive that is the case of making only in sql. Thanks for help.
I have a table with birthdays in the format: mm-dd (no year) Examples: 02-31, 05-20, 12-31. I would like a sqlite query to calculate how many days are left until the next birthday. Even for the dates that are smaller than the present day. I did it in B4A code but was not elegant. I belive that is the case of making only in sql. Thanks for help.
Erel B4X founder Staff member Licensed User Longtime User Jul 5, 2016 #2 Eme Fibonacci said: I did it in B4A code but was not elegant. Click to expand... How did you implement it? You should use DateUtils. Upvote 0
Eme Fibonacci said: I did it in B4A code but was not elegant. Click to expand... How did you implement it? You should use DateUtils.