Date fields don't look or behave the way you want? Take control by editing the date field's Properties page:
Access this page in one of the following ways:
If you're in a form, right-click the field label and select Edit this field's properties.
If you're in a report, left-click or right-click the column heading and select Edit this field's properties.
In the table bar on any application page, click the table containing the field you want to change. Within the menu that appears, select Customize --tablename-- table > Fields.
In the menu bar on any application page, select Customize > Tables. Within the list on the left side of the page, click the table that contains the field you want to change and click the Fields tab.
When users fill out a data-entry from, 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.
QuickBase automatically displays dates in the following format: 07-05-2005. You can format the date differently, if you want. To do so, select one or more of the following options under Date Options within the Format section:
Display Month Alphabetically results in this format: JUL-05-2005
Display Day of the Week inserts the day of the week in front of the date. You'll see something like: Tuesday, 07-05-2005
'Smart Date' display shows
the date in the following format: 07 8, 2001
That may not look so smart, but the appeal of this format doesn't
lie in its looks. Smart date display is intelligent enough to know
what year it is. If a date falls in the current year, smart date display
leaves it out. If a date falls in any other year, it appears.
Tip: If you want you display the date in this format: date as: JUL 5, 2005, turn on both the Display Month Alphabetically and 'Smart Date' Display checkboxes. But remember, only dates that are not in the current year will show the year. Others will appear like this: JUL 5.
© 1999-2010 Intuit Inc. All rights reserved.