4D v13

PV SET CELL DATE TIME VALUE

Home

 
4D View v13
4D View Language
PV Cell value
PV SET CELL DATE TIME VALUE

PV SET CELL DATE TIME VALUE 


 

PV SET CELL DATE TIME VALUE ( area ; column ; row ; date ; time ) 
Parameter Type   Description
area  Longint in 4D View area
column  Longint in Cell column number
row  Longint in Cell row number
date  Date in Date cell value
time  Time in 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.

Example  

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

 
PROPERTIES 

Product: 4D
Theme: PV Cell value
Number: 15843

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV GET CELL DATE TIME VALUE
PV Get cell value type