- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
field type - date time [2016/09/14 18:19] |
field type - date time [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Date & Time ====== | ||
+ | The date and time Field stores a date and time. Internally, the stored value for all date/time Fields is a timestamp which equals the number of seconds elapsed from January 1, 1970 to the time specified. Outwardly, though, it appears as a calendar date and a time of the day. The display of this field is affected by [[Timezone and Locale|Timezone and Locale]] settings. | ||
+ | ===== How to Create ===== | ||
+ | - Click the {{:presentation-layer:field-plus.png|}} to add a field in your [[Form|form]]. | ||
+ | - Choose "New Field" | ||
+ | - Select the table you wish to add the field to. Most of the time, this will be the current [[Table|table]] you are on, called the current [[Context|context]]. | ||
+ | - Select a field name and click "Choose Type". | ||
+ | - Choose "Date and Time" from the list of field types. | ||
+ | - You can continue adding fields or click the "Select" button to finish adding. | ||
+ | ===== Features ===== | ||
+ | Field features can be edited by clicking on the orange field icon {{:datetime.png|}} when the [[Presentation Layer|presentation layer]] is displayed. | ||
+ | |||
+ | ==== Field Label ==== | ||
+ | * [[Field Setting - Field Label|Field Label]] | ||
+ | * [[Field Setting - Display Alternate Label]] (affects this form only) | ||
+ | |||
+ | ==== Grid Appearance ==== | ||
+ | |||
+ | * [[Field Setting - Column Span|Column Span]] | ||
+ | * [[Field Setting - Row Span|Row Span]] | ||
+ | |||
+ | ==== Tooltip ==== | ||
+ | * [[Field Setting - Tooltip|Tooltip]] | ||
+ | * [[Field Setting - Descriptive Text|Descriptive Text]] | ||
+ | * [[Field Setting - Display Alternate Descriptive Text|Display Alternate Descriptive Text]] (affects this form only) | ||
+ | |||
+ | ==== Field Format ==== | ||
+ | * [[Application Setting - Date Format for all Date and Date Time Fields|Date Format for all Date and Date Time Fields]] | ||
+ | * [[Application Setting - Time Format for all Date Time and Time Fields|Time Format for all Date Time and Time Fields]] | ||
+ | * [[Field Setting - Specify a Date Format|Specify a Date Format]] | ||
+ | * [[Field Setting - Specify a Time Format|Specify a Date Format]] | ||
+ | * [[Field Setting - Specify Alternate Date Format|Specify Alternate Date Format]] (affects this form only) | ||
+ | * [[Field Setting - Specify Alternate Time Format|Specify Alternate Date Format]] (affects this form only) | ||
+ | * [[Field Setting - Sizing|Length]] | ||
+ | |||
+ | ==== Block Association ==== | ||
+ | * [[Field Setting - Temporary Block Association|Temporary Block Association]] | ||
+ | * [[Field Setting - Global Block Association|Global Block Association]] | ||
+ | |||
+ | ==== Default Value ==== | ||
+ | * [[Field Setting - Default Value|Default Value]] | ||
+ | |||
+ | ==== Regionalization ==== | ||
+ | * [[Field Setting - Regionalization|Regionalization]] | ||
+ | |||
+ | ==== Validation ==== | ||
+ | * [[Field Setting - Required|Required]] | ||
+ | |||
+ | ==== Audit History ==== | ||
+ | * [[Field Setting - Audit This Field|Audit This Field]] | ||
+ | * [[Field Setting - Show Audit History|Show Audit History]] | ||
+ | |||
+ | ==== View Only ==== | ||
+ | * [[Field Setting - View Only|View Only]] | ||
+ | |||
+ | |||
+ | ===== Field parts ===== | ||
+ | The date and time Field has four interface parts but only one storage part. | ||
+ | |||
+ | Interface Parts | ||
+ | |||
+ | * Date | ||
+ | * Hour | ||
+ | * Minute | ||
+ | * AM/PM | ||
+ | |||
+ | Storage Part | ||
+ | * Timestamp | ||
+ | ===== Output formats ===== | ||
+ | The address field has 25 different output formats. The following are examples of output when 09/09/2009 9:09 PM is stored in the date and time Field: | ||
+ | |||
+ | * Full Field - 09/09/2009 09:09 PM | ||
+ | * WX Stored Value - 1252544940 (The number of seconds from January 1, 1970 | ||
+ | * AM/PM Lowercase - pm | ||
+ | * AM/PM Uppercase - PM | ||
+ | * Day of the Month - 9 | ||
+ | * Day of the Month Suffix - th (For use in expressions such as 'The 9th of September, 2009') | ||
+ | * Day of the Month With Leading Zero - 09 | ||
+ | * Day of the Week - Wednesday | ||
+ | * Day of the Week Abbreviated - Wed | ||
+ | * Day of the Week Number - 3 (The number that Wednesday takes as a day of the week, with Monday as 1) | ||
+ | * Day of the Year - 252 | ||
+ | * Hour - 9 | ||
+ | * Hour 24 - 21 | ||
+ | * Hour 24 With Leading Zero - 21 | ||
+ | * Hour With Leading Zero - 09 | ||
+ | * Minute - 9 | ||
+ | * Month Name - September | ||
+ | * Month Name Abbreviated - Sep | ||
+ | * Month - 9 | ||
+ | * Month With Leading Zero - 09 | ||
+ | * Second - 0 (This return type is only useful when NOW() or a literal number is set to a Date and Time field through actions). | ||
+ | * Timestamp - 1252544940 (Same as WX Stored Value) | ||
+ | * Week of the Year - 37 (Returns the sequential number of the week that the time falls in) [[Expression Function - Week of the Year|Expression Function - Week of the Year]] | ||
+ | * Year 4 Digit - 2009 | ||
+ | * Year 2 Digit - 09 | ||
+ | ===== Acceptable inputs ===== | ||
+ | Although a date and time Field is stored internally as a number, when interacting with the Field on a page, you must input a day and a time. | ||
+ | |||
+ | Setting the date is done by clicking on the date part of the Field and clicking on a day from the calendar flyout which will appear. | ||
+ | |||
+ | * Navigating between months is done by using the <Prev and Next> links or by using the month drop-down for selecting the month explicitly. | ||
+ | * The year can be selected by using the year drop-down. | ||
+ | * The Today link in the midde of the top of the calendar flyout selects the current day. | ||
+ | * The Clear link in the bottom left corner of the calendar flyout clears the currently selected day and closes the calendar flyout | ||
+ | * The Close link in the bottom right corner closes the calendar flyout. | ||
+ | * Clicking a day's symbol (Su, Mo, etc) near the top of the flyout reorganizes the calendar with that day as the first day of the week. | ||
+ | |||
+ | Setting the hour and minute are done by typing a number into the hour and minute Field Parts. There is no validation on these parts, though only two characters are allowed in each Field Part. Entering non-real times is allowed, though, and is handled by WorkXpress by adjusting the time by however many hours or minutes exceed 24 or 60, respectively. For example, if 12/31/1985 25:00 AM is entered and saved into a Date and Time field, WorkXpress would adjust the value to 01/01/1986 1:00 AM. Selecting AM or PM is done by using the AM/PM drop-down. | ||
+ | |||
+ | ==== Setting With Actions ==== | ||
+ | |||
+ | When setting the Date & Time field through actions, two different input formats may be used. As with other field types, the stored value from another Date & Time field may be used to save into a Date & Time field. Since the stored value for these fields is a timestamp, any timestamp value may also be used to save into a Date & Time field (may be calculated from an expression or extracted from a Date or Time field). | ||
+ | |||
+ | In addition to this, the text output of the Date & Time field (e.g. 04/23/1985 6:08 AM) may also be used to save into the Date & Time field. Because of this, you may also construct such a text string and use it to save into the Date & Time field. For instance, if I wanted to extract the date from a Date field and the Time from a Time field, combine them, and save the result in a Date & Time field, I could use the Displayed Value output for the Date field and the Displayed Value output for the Time field, and save it into a Date & Time field. | ||
+ | |||
+ | Ex. Suppose you have a Date field called Event Date and two time fields called Start Time and End Time on an item called Event and you needed to save two date & time fields called Start Date and Time and End Date and Time. To do this, set up actions to set the expression ${Event - Event Date} ${Event - Start Time} into the Start Date and Time field and the expression ${Event - Event Date} ${Event - End Time} into the End Date and Time field. | ||
+ | |||
+ | ===== Filters ===== | ||
+ | The date/time field can be filtered with the [[Query Builder - Filter#Time-Type Filters|time-type filters]]. | ||
+ | |||
+ | ===== Internationalization and Browser Settings ===== | ||
+ | Date and Time settings should change automatically in non-US countries. For more information, read the [[Field Setting - Regionalization|Regionalization Field Settings]] page, or if you need to change your settings manually to simulate being in another country, [[Browser Settings - Date and Time|try out these settings]]. |