Command PV SET CELL DATE TIME VALUE

PV SET CELL DATE TIME VALUE

version 6.8

PV SET CELL DATE TIME VALUE (area; column; row; date; time)

Parameter	Type		Description
area	Longint		4D View area
column	Longint		Cell column number
row	Longint		Cell row number
date	Date		Date cell value
time	Time		Time cell value

The PV SET CELL DATE TIME VALUE command assigns the values date and time as a single value to the cell assigned by column and row.

This method requests a date and time for a meeting, with the latter being pushed ahead to the next day, a half-hour later. It then displays the new appointment in cell A1:

   C_DATE($Date)  `Meeting date
   C_TIME($Time)  `Meeting time
   
   $Date:=Date(Request("Date of meeting";String(Current date)))
   If ($Date#!00/00/00!)  `Date valid
      $Time:=Time(Request("Time of meeting";Time string(Current time)))
      If ($Time#†00:00:00†)  `Time valid
             `Reschedule the meeting a day later and 1/2 hour later then assign to cell A1
         PV SET CELL DATE TIME VALUE (Area;1;1;$Date+1;$Time+†00:30:00†)
         PV GET CELL DATE TIME VALUE (Area;1;1;$Date;$Time)  `Read info
         ALERT ("The meeting has been pushed ahead to  "+String($Date)+" at "+Time string($Time))
      End if 
   End if 

PV GET CELL DATE TIME VALUE, PV Get cell value type.