[Solved] How to use date functions in Thunkable X

Hi @ali4oman and @bymaho,
Answer 1:
If you have a table of how many days are in each month, you can add a number of days to your date by:

  1. if (days left in month) < number, set new date to last day of original month, set number to (number - (days left in month)).
    Example: 14 Feb 2019 + 100 days = 28 Feb 2019 + 86 days
  2. For as long as the next month of days is less than number, add 1 month to new date and take that many days away from number
    Example: 28 Feb 2019 + 86 days = 31 Mar 2019 + 55 days = 30 Apr 2019 + 25 days
  3. Add the remaining number to your date
    Example: 30 Apr 2019 + 25 days = 25 May 2019

Answer 2:
Using a method like above, if two dates are in different months the # of days between them is (days between start date and end of month) + (days between end date and start of month) + (number of days in any full months between start date and end date)

Answer 3:
If you use the date input in your app, you can see what the day of the month was on a given date. If you want to type a date and get a day of the week, use an API with our Web API component for this purpose.

Answer 4: There sure is!

Hope this helps :smile:

4 Likes