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:
- 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 - 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 - 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