4D v18
VP SET DATE VALUE
- 4D View Pro Reference
-
- 4D View Pro Language
-
- About 4D View Pro commands
- Handling 4D View Pro areas
- 4D View Pro Constants
- VP ADD FORMULA NAME
- VP ADD RANGE NAME
- VP ADD SELECTION
- VP ADD STYLESHEET
- VP All
- VP Cell
- VP Cells
- VP Column
- VP Combine ranges
- VP Convert from 4D View
- VP Convert to pictureNew
- VP EXPORT DOCUMENTUpd
- VP Export to object
- VP FLUSH COMMANDS
- VP Font to object
- VP Get active cell
- VP Get cell style
- VP Get default style
- VP Get formula
- VP Get formula by name
- VP Get formulas
- VP Get names
- VP Get print infoNew
- VP Get selection
- VP Get stylesheet
- VP Get stylesheets
- VP Get value
- VP Get values
- VP IMPORT DOCUMENT
- VP IMPORT FROM OBJECT
- VP Name
- VP NEW DOCUMENT
- VP Object to font
- VP PRINTNew
- VP REMOVE NAME
- VP REMOVE STYLESHEET
- VP RESET SELECTION
- VP Row
- VP SET ACTIVE CELL
- VP SET ALLOWED METHODS
- VP SET BOOLEAN VALUE
- VP SET BORDER
- VP SET CELL STYLE
- VP SET DATE TIME VALUE
- VP SET DATE VALUE
- VP SET DEFAULT STYLE
- VP SET FIELD
- VP SET FORMULA
- VP SET FORMULAS
- VP SET NUM VALUE
- VP SET PRINT INFONew
- VP SET SELECTION
- VP SET TEXT VALUE
- VP SET TIME VALUE
- VP SET VALUE
- VP SET VALUES
- VP SHOW CELL
- 4D View Pro Range Object Properties
- 4D View Pro Print Attributes
- 4D View Pro Cell Format
- 4D View Pro Style Objects and Style Sheets
VP SET DATE VALUE
| VP SET DATE VALUE ( rangeObj ; dateValue {; formatPattern} ) | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |
|
Range object | |||||
| dateValue | Date |
|
Date value to set | |||||
| formatPattern | Text |
|
Format of value | |||||
The VP SET DATE VALUE command assigns a specified date value to a designated cell range.
In rangeObj, pass a range of the cell(s) whose value you want to specify. If rangeObj includes multiple cells, the value specified will be repeated in each cell.
The dateValue parameter specifies a date value to be assigned to the rangeObj.
The optional formatPattern defines a pattern for the dateValue parameter. Pass any custom format or you can use one of the following constants:
| Constant | Value | Comment |
| vk pattern long date | "_longDatePattern_" | ISO 8601 format for the full date in current localization. USA default pattern: "dddd, dd MMMM yyyy" |
| vk pattern month day | "_monthDayPattern_" | ISO 8601 format for the month and day in current localization. USA default pattern: "MMMM dd" |
| vk pattern short date | "_shortDatePattern_" | Abbreviated ISO 8601 format for the date in current localization. USA default pattern: "MM/dd/yyyy" |
| vk pattern year month | "_yearMonthPattern_" | ISO 8601 format for the month and year in current localization. USA default pattern: "yyyy MMMM" |
For information on patterns and formatting characters, please refer to the 4D View Pro Cell Format section.
//Set the cell value to the current date
VP SET DATE VALUE(VP Cell("ViewProArea";4;2);Current date))
//Set the cell value to a specific date with a designated format
VP SET DATE VALUE(VP Cell("ViewProArea";4;4);Date("12/25/94");"d/m/yy ")
VP SET DATE VALUE(VP Cell("ViewProArea";4;6);!2005-01-15!;vk pattern month day)
Product: 4D
Theme: 4D View Pro Language
Number:
9576
Created: 4D v17 R4
4D View Pro Reference ( 4D v18)
