Forum Discussion

SylvesterOkelek's avatar
SylvesterOkelek
Qrew Trainee
5 years ago

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


------------------------------
Sylvester
------------------------------
Formulas and functions

2 Replies

Sort By
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    Qrew Captain
    5 years ago
    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
    ------------------------------
    • SylvesterOkelek's avatar
      SylvesterOkelek
      Qrew Trainee
      5 years ago
      Thanks Sharon.... Works great!

      ------------------------------
      Sylvester Okeleke
      ------------------------------