Date/time values are one of the types of Field values.
When you configure a field to have a date/time value, Dabble will only allow the field to contain a calendar date or range of dates. The date may include a time of day, but does not require it. (A time with no date will be interpreted for the current date.)
Note: If you wish to measure an amount of time with no specific date, use a duration value.
The main purpose of date/time values is to allow you create a Calendar view where your data is shown on a monthly, weekly or daily calendar according to a particular field. The option to switch to calendar view will be available whenever you are looking at entries that have one or more date/time fields.
You can also create Filters that deal mathematically with dates, e.g. “Date: >= Today” or “Birthday: < 1980”. See Value filters for more detail.
You can change a field to have a date/time value using the Field configuration. When you do this, existing data in the field will be converted. If text cannot be interpreted as a valid date, it will be marked as Invalid data. All future data entered into the field will also be treated as a date.
In the Field configuration there is one option you can change for date/time value fields. You can specify a default date for when entries are created with this field. This only applies to the future: existing entries will not have their values changed. You can use a particular date/time or any of the natural language that Dabble DB understands.
Dabble will try to interpret any text that looks like a date or a date range. The system understands most English-language and numeric shorthand, as well as some words like “today”, “tomorrow” and “next week”. If you enter a date using shorthand or using a word like “today”, Dabble will process it so that the next time you see it (e.g., after you have saved), it will be written in a standard, consistent format.
When dates are entered numerically (e.g. 1/10/06) there is the potential for confusion over whether the date is month/day/year or day/month/year format. Dabble will follow whichever one is specified in the database locale settings. (The default for new accounts is month/day/year.)
You can use all of these terms when entering Field values.
You can also use them when writing Value filters to control which entries are displayed in a view. In addition, you can use “before” or “after”, and also “from now” or “ago” (to refer to the future or past respectively).