Quick Base Discussions

Expand all | Collapse all

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

  • 1.  Can you set the default time on a date/time field

    Posted 11-01-2016 16:16

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



  • 2.  RE: Can you set the default time on a date/time field

    Posted 11-01-2016 16:49
    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)


  • 3.  RE: Can you set the default time on a date/time field

    Posted 04-06-2017 15:09
    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.