VP SET DATE TIME VALUE

Home

4D v19


VP SET DATE TIME VALUE ( rangeObj ; dateValue ; timeValue {; formatPattern} )

Parameter	Type	Description
rangeObj	Object	Range object
dateValue	Date	Date value to set
timeValue	Time	Time value to set
formatPattern	Text	Format of value

Description

The VP SET DATE TIME VALUE command assigns a specified date and time value to a designated cell range.

In rangeObj, pass a range of the cell(s) (created for example with VP Cell or VP Column) 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 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 4D View Pro Cell Format section.

Example

  //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)