Help with Date field for Timesheet Table
Please help. I created a Date field {Week of} within the Time sheet table. How can I make this [Week of} field to only allow users to select a particular date? For example, I wouldn't want users to ...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendIf 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
------------------------------
- Thanks Sharon.... Works great!
------------------------------
Sylvester Okeleke
------------------------------
