4D View v16PV SET CELL DATE TIME VALUE |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D View v16
PV SET CELL DATE TIME VALUE
|
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
Product: 4D View
Theme: PV Cell value
Number:
15843
Created: 4D View 6.8
4D View Language ( 4D View v16)