Forum Discussion
Quick_BaseJunki
5 years agoQrew Captain
If the selection only needs to be within the current week (and not a specific day), have you thought of using a formula field instead?
This date formula results in the first day of the week the record was created (or if not yet saved the first day of today's week).
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
This date formula results in the first day of the week the record was created (or if not yet saved the first day of today's week).
If(IsNull([Record ID#]),FirstDayOfWeek(Today()),FirstDayOfWeek(ToDate([Date Created])))​
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
- SylvesterOkelek5 years agoQrew TraineeThanks Sharon.... Works great!
------------------------------
Sylvester Okeleke
------------------------------