VP SET DATE TIME VALUE
VP SET DATE TIME VALUE ( rangeObj : Object ; dateValue : Date ; timeValue : Time {; formatPattern : Text } )
Parâmetro | Tipo | Descrição | ||
---|---|---|---|---|
rangeObj | Object | -> | Objeto intervalo | |
dateValue | Date | -> | Valor date a definir | |
timeValue | Hora | -> | Valor hora a definir | |
formatPattern | Text | -> | Formato do valor |
Descrição
The VP SET DATE TIME VALUE
command assigns a specified date and time value to a designated cell range.
Em rangeObj, passe um intervalo de células (criado, por exemplo, com VP Cell
ou VP Column
) cujo valor você deseja especificar. 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 timeValue parameter specifies a time value (expressed in seconds) to be assigned to the rangeObj.
The optional formatPattern defines a pattern for the dateValue and timeValue parameters. For information on patterns and formatting characters, please refer to the Date and time formats section.
Exemplo
//Set the cell value as the current date and time
VP SET DATE TIME VALUE(VP Cell("ViewProArea";6;2);Current time;Current date;vk pattern full date time)
//Set the cell value as the 18th of December
VP SET DATE TIME VALUE(VP Cell("ViewProArea";3;9);!2024-12-18!;?14:30:10?;vk pattern sortable date time)
Veja também
4D View Pro cell format
VP SET DATE VALUE
VP SET TIME VALUE
VP SET VALUE