Now DataWindow expression function
Description
Obtains the current time based on the system time of the client
machine.
Syntax
|
1 |
<span>Now</span> ( ) |
Return Values
Time. Returns the current time based on the system time of
the client machine.
Usage
Use Now to compare a time to the system
time or to display the system time on the screen. The timer interval
specified for the DataWindow object determines the frequency at which the
value of Now is updated. For example, if the
timer interval is one second, it is updated every second. The default
timer interval is one minute (60,000 milliseconds).
Examples
This expression returns the current system time:
|
1 |
<span>Now</span>() |
This expression sets the column value to 8:00 when
the current system time is before 8:00 and to the current time if
it is after 8:00:
|
1 |
If(<span>Now</span>() < 08:00:00, '08:00:00', String(<span>Now</span>())) |
The displayed time refreshes every time the specified time
interval period elapses.
If a static value of time is required (for example,
the time when a report has been executed or the retrieve has started),
you can use a static text field that you modify as follows:
|
1 |
//Set the time when the report was executed in <br>//the text field t_now |
|
1 |
dw1.Modify("t_now.text='"+ String(Now(),"hh:mm")+"'") |
|
1 |
//execute the report |
|
1 |
dw1.retrieve() |