Skip to main content
Question

Help with Date field for Timesheet Table

  • April 21, 2020
  • 0 replies
  • 21 views
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
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
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 Junkie
https://quickbasejunkie.com
------------------------------
Terms & ConditionsAccessibility statement