LVREFRESHDATETIME Function

Using the LVREFRESHDATETIME function, you can query the date and time when the cell location was last refreshed.

You can use the LVREFRESHDATETIME function in the following ways:

• Type the function syntax into a worksheet cell.
• Complete the function parameters in the Function Arguments dialog.

LVREFRESHDATETIME syntax

In the worksheet cell, type:

=LVREFRESHDATETIME([long_format])

where:

• long_format is an optional parameter for the date and time format. Specify one of the following values:

  Values	Description
  TRUE	The refresh date and time appear in the long format, as specified in your system.
  FALSE	The refresh date and time appear in the short format, as specified in your system.

If you do not specify a value for long_format, the refresh date and time appear in the short format, as specified in your system.

For example:

=LVREFRESHDATETIME(TRUE)

Querying the refresh date and time using the Function Arguments dialog

You can query the refresh date and time by completing the function parameters in the Function Arguments dialog.

To query the refresh date and time:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVREFRESHDATETIME. The Function Arguments dialog opens.
3. Complete the following fields:

   Field	Description
   <long_format>	Optionally, specify the date and time format.

4. Click OK. [Refresh required] appears in the worksheet cell.
5. Refresh the worksheet. For more information, see Refreshing data from cells containing Longview Functions. The query data appears in the worksheet.