Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Multi-Select Dates

I like Ahuva's idea. If you make 14 records they can calculate the 14 days dynamically based on Today()

------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------

2 Replies

KyleMcKinnies
Qrew Member
4 years ago
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
------------------------------
- AhuvaBrown
  Qrew Cadet
  4 years ago
  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
  ------------------------------