> SET VAR vDate DATE = NULL > EDIT USING formname > -- Notice that the default value for Variable > Date/Time Picker is > being displayed as today's date - 15. > If the user does not touch the Variable > Date/Time Picker or > change the date/calendar, it will NOT assign > any values to > vDate variable and the vDate will still be > NULL.
To my mind, although an improvement on the current Date/Time pickers, this situation is not absolutely ideal because: 1. What is displayed in the control does not truly reflect the underlying value of the variable or column. This is the ONLY R:Base control where this is true -- everything else does show you what's in the variable. 2. There's no way in this situation to use a Date/Time Picker to show or enter a NULL value. Therefore, you cannot use these controls on a column or variable that might require the user to specify a NULL. My preference would be for the Date/Time picker to display a blank field when the underlying value is NULL, and to allow the user to hit DELETE with the field selected to set the underlying column or variable to NULL. -- Larry
