- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
The selected file /tmp/fileajGzsx could not be uploaded, because the destination sites/default/files/css/css_a91cd284035e73ba34d112bfed2f5a16.css is not properly configured. The selected file /tmp/fileP4ZKKw could not be uploaded, because the destination sites/default/files/css/css_de1aa27776f1462d2b0d83a80ce4b92d.css is not properly configured.
The date Field stores a date. 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, which for a date Field is 12:00 AM on the day specified. Outwardly, though, it appears as a calendar date.
Since a date Field is just a number, setting a default value requires that you supply the Expression Builder with an expression which will result in a number. Thus if setting a date Field to default to a value saved in another date or time Field, you must use the WX Stored Value Output format, which will evaluate to a number.
Though a date is stored internally as a number, when interacting with the Field on a page, you must input a date through the calendar flyout.
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.
When setting the Date field through actions, two different input formats may be used. As with other field types, the stored value from another Date field may be used to save into a Date field. Since the stored value for these fields is a timestamp, any timestamp value may also be used to save into a Date field (may be calculated from an expression or extracted from a Date & Time or Time field).
In addition to this, the text output of the Date field (e.g. 04/23/1985) may also be used to save into the Date field. Because of this, you may also construct such a text string and use it to save into the Date field. For instance, if I wanted to set a Date field with a date seven days after the date saved in a different Date field, I could use the arithmetic function to add 7 to the Day of the Month output, and set the mm/dd/yyyy format into the target field.
Ex. Suppose you have a Date field called Task Date and another Date field called Callback Date on an item called Task and you needed to set the callback date to exactly one week after the Task Date. To do this, you could set the expression ${Task - Task Date (Month)}/+=(${Task - Task Date (Day of the Month)}+7)/${Task - Task Date (Year 4 Digit)} into the Callback Date field.
The date Field has 25 different output formats. The following are examples of output when 09/09/2009 is stored in a date Field:
The Date field can be filtered with any of the six standard time-type filters.