Differences
This shows you the differences between the selected revision and the current version of the page.
| date_and_time_values 2008/03/05 06:54 | date_and_time_values 2009/12/29 17:39 current | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Date/time values are one of the types of [[field values]]. | 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.) | + | 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 (and a time with no date will be interpreted as the current date.) |
| **Note:** If you wish to measure an amount of time with no specific date, use a [[Duration values|duration value]]. | **Note:** If you wish to measure an amount of time with no specific date, use a [[Duration values|duration value]]. | ||
| Line 22: | Line 22: | ||
| ==== DD/MM/YY and MM/DD/YY ==== | ==== DD/MM/YY and MM/DD/YY ==== | ||
| - | 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 [[Locale settings|database locale settings]]. (The default for new accounts is month/day/year.) | + | 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. The default is month/day/year, but you can specify a different arrangement for your account in the [[Locale settings|database locale settings]]. |
| ==== Examples of dates that Dabble understands ==== | ==== Examples of dates that Dabble understands ==== | ||
Dabble DB and the Dabble DB logo are registered trademarks of Smallthought Systems Inc. Read our privacy policy.