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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
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)
Photo of Johnny QuickBase

Johnny QuickBase

  • 300 Points 250 badge 2x thumb
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.