GetItemDateTime – PB Docs 150

GetItemDateTime method (DataWindows)


Gets data whose type is DateTime from the specified buffer
of a DataWindow control or DataStore object. You can obtain the
data that was originally retrieved and stored in the database from
the original buffer, as well as the current value in the primary,
delete, or filter buffers.

note.png Separate method names for the Web DataWindow server

Separate method names, GetItemDateTimeEx, GetItemDateTimeByColNum, and GetItemDateTimeByColNumEx,
are provided as alternative syntaxes for the Web DataWindow server
component, which cannot use overloaded methods.


DataWindow type

Method applies to


DataWindow control, DataWindowChild object, DataStore


Server component



[Web DataWindow server component]




A reference to the DataWindow control,
DataStore, or child DataWindow in which you want to obtain the DateTime
data contained in a specific row and column.


A value identifying the row location
of the data.


The column location of the data. The
datatype of the column must be DateTime. Column can
be a column number or a column name. The column number is the number
of the column as it is listed in the Column Specification view of
the DataWindow painter—not
necessarily the number of the column in the Design view.

To get the contents of a computed field, specify the name
of the computed field for column. Computed
fields do not have numbers.

dwbuffer (optional)

A value identifying the DataWindow buffer
from which you want to get the data.

For a list of valid values, see DWBuffer.

originalvalue (optional)

A boolean indicating whether you want
the original or current values for row and column:

  • True – Returns
    the original values, that is, the values initially retrieved from
    the database.

  • False – (Default) Returns
    the current values.

If you specific dwbuffer, you must also
specify originalvalue.

Return Values

Returns the DateTime or Timestamp value in the specified row
and column. Returns null if the column value is null or if there
is no DataWindow object assigned to the DataWindow control or DataStore. Returns
1900-01-01 00:00:00.000000 if any other error occurs.

If any argument value is null, in PowerBuilder the method
returns null.


Use GetItemDateTime when you want to get information from
the DataWindow’s buffers. To find out what the user entered
in the current column before that data is accepted, use GetText.
In the ItemChanged or ItemError events, use the data argument.

To access a row in the original buffer, specify the buffer
that the row currently occupies (primary, delete, or filter) and
the number of the row in that buffer. When you specify true for originalvalue,
the method gets the original data for that row from the original

note.png Datatype mismatch

An execution error occurs when the datatype of the DataWindow
column does not match the datatype of the method—in this
case, DateTime.

Computed fields displaying date or time values have a datatype
of DateTime, not date or time. Always use GetItemDateTime to
get their value, not GetItemDate or GetItemTime.


These statements set as_of to the current
DateTime data in the primary buffer for row 3 of the column named
start_dt in the DataWindow dw_emp:

These statements set as_of to the current
DateTime data in the delete buffer for row 3 of the end_dt
column of dw_emp:

These statements set AsOf to the original DateTime
data in the primary buffer for row 3 of the end_dt column
of dw_emp:

See Also

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x