LinkedIn
Twitter
It looks like AppSheet doesn't really have the required functions for generating a sequence between two values in the formulas at least.
You could do it using another table that includes a list of the dates (similar to what is mentioned here). If you want to make this more dynamic (so you wouldn't need to manage that table,) you could use a Google Sheet as a data source with a table that lists a large set of dates based on a formula. (For example, something like this
=ArrayFormula(Today()+Row(A2:A)-60))
Will start at the date 60 days prior to today and list all the dates until it hits the last row in your sheet (thus moving every day so you never have to go and update the formula)).
Then you would be able to "Select" from that list the values that fall between your start and end dates, and present those as your list of dates.
Alternatively, if you don't actually need the list of dates. You could use the valid if section to constrain the users selections based on the start and end dates.
If you're trying to get someone to choose a date between your start and end. Make a field of the type "Date"
The change the valid if to reference whether [_this] is between those dates and include an error message to communicate this accurately.
valid if:
and([_this]>=[Start Date],[_this]<=[End Date])
Invalid error:
"You must select a date between "&[Start Date]&" and "&[End Date]
The downside of this is, the date picker doesn't actually block out the dates that are invalid. It waits to see what the user selects and then checks the validation when they try to progress. But it's a slightly more built in solution if it fits your need then having to link in another table to reference the list of dates.
