VP SET DATE VALUE
VP SET DATE VALUE ( rangeObj : Object ; dateValue : Date { ; formatPattern : Text } )
| Paramètres | Type | Description | ||
|---|---|---|---|---|
| rangeObj | Object | -> | Objet plage | |
| dateValue | Date | -> | Valeur date à fixer | |
| formatPattern | Text | -> | Format de la valeur |
Description
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. Passez un format personnalisé ou utilisez ou utilisez l'une des constantes suivantes :
| Constante | Description | Configuration par défaut des US |
|---|---|---|
vk pattern long date | Format ISO 8601 long pour la date | "dddd, dd MMMM yyyy" |
vk pattern month day | Format ISO 8601 pour le mois et le jour | "MMMM dd" |
vk pattern short date | Format ISO 8601 court pour la date | "MM/dd/yyyy" |
vk pattern year month | Format ISO 8601 pour le mois et l'année | "yyyy MMMM" |
For information on patterns and formatting characters, please refer to the Date and time formats section.
Exemple
//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)