Forum Discussion

ShontaySmith's avatar
ShontaySmith
Qrew Assistant Captain
9 years ago

Can you set the default time on a date/time field

I would like to set the default time to 8:00 am and the default date two days from the current date

Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    If this is on a form, then you can have a formula calculate that date / time value and then have a form rule to populate the date/time field if the date time field is blank.

    The formula would be something like

    var  TimeOfDay TOD = ToTimeOfDay("8:00 am");

    var date TwoDays = today() + days(2);

    ToTimeStamp($TwoDays, $TOD)
  • JohnParham's avatar
    JohnParham
    Qrew Cadet
    8 years ago
    What if I want the default for a date field to be something other than today.  Don't want a rule because that means I have to interact with the form.