Help with Date field for Timesheet Table

Question

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 select a previous date but would want them to enter a date for this week only when entering their timesheet.

------------------------------
Sylvester
------------------------------

------------------------------Sylvester ------------------------------

quickbasejunkie · Answer

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).
If(IsNull([Record ID#]),FirstDayOfWeek(Today()),FirstDayOfWeek(ToDate([Date Created])))​------------------------------Sharon Faust (QuickBaseJunkie.com)Founder, Quick Base Junkiehttps://quickbasejunkie.com------------------------------

sylvesterokelek · Answer

Thanks Sharon.... Works great!------------------------------Sylvester Okeleke------------------------------

Forum Discussion

Help with Date field for Timesheet Table

2 Replies

Related Content

Snapshot Fields

Reference tables quandary

Table is missing

Consolidate Field Types

Checkbox Fields Vs Multi-Select Fields for Tracking