Configure Date Fields

Prev Next

Date fields don't look or behave the way you want? Take control by editing   the Date field's properties.

Set the Default date to be today

When users fill out a data-entry form, you can help them out. Have Quickbase  automatically enter today's date in a date field. The program doesn't  prohibit other dates from being entered, it just gives users a head start.  To automate this entry: On the field's Properties page, next to Default  value, turn on the Today checkbox.

Tip: Users entering data  in Quickbase can also take a shortcut. In any date field, press the "t"  key. When you do so, Quickbase enters today's date. You can also use the  keyboard to go back or forward one day. If there's a date in the field,  select it and press "[" to change the value to the day before the existing  date, or press "]" for the day after.

Change the Date Format

Quickbase automatically displays dates in the following format: 07-05-2011. You can format the date differently,  if you want. To do so, select one or more of the following options under  Format within the Display  section:

  • Show the month as a name  results in this format: JUL-05-2011

  • Show the day of the week inserts the day of the week in front of the date. You'll see something like:  Tuesday, 07-05-2011

  • Don't show the year for dates in the current year shows the date in the following format: 07 5, 2011. That may not look so smart, but the appeal of this format doesn't lie in its looks. This date display is intelligent enough to know what year it  is. If a date falls in the current year, the date display leaves the  year out. If a date falls in any other year, the year appears.

Tip: If you want you display the date in this format:  date as: JUL 5, 2011, turn on both the Show the month as a name and Don't show the year for dates in the  current year checkboxes. But remember, only dates that  are not in the current year will show the year, and dates in the current  year look like this: JUL 5.

Related topics: