Multi-Select Dates
I am working in our expense report app. I would like the user to be able to choose multiple dates to be paid a stipend when traveling. What is the best way to accomplish this in a single field? -...
Forum Discussion
I like Ahuva's idea. If you make 14 records they can calculate the 14 days dynamically based on Today()
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
That worked great, thanks again. One more question, is there a formula that could count the number of entries (days) selected in the multi-select field?
------------------------------
Kyle McKinnies
------------------------------
------------------------------
Kyle McKinnies
------------------------------
- Are the dates working dynamically, meaning they update according to the current day?
For counting the selections, try converting the multi-select text to regular text and do something like this:
Count(
Part([field],1,";"),
Part([field],2,";"),... up to max values
)
I think you might have to trim each part or a blank space will be added to the count. Trim(Part([field],1,";))
------------------------------
Ahuva Brown
------------------------------
