With mode hQueryDefault date and time values are automatically translated from WinDev to AS/400 format.
dToday is Date
HExecuteQuery(REQ_3,hQueryDefault,dToday)
When the value is hard coded, it must be in 8 digits format (YYYYMMDD).
HExecuteQuery(REQ_3,hQueryDefault,"20080125")
See connection extended info DATETYPE and TIMETYPE for information about handling date and time values stored in different data types on AS/400.
With the hQueryWithoutCorrection mode, date and time values must be given in *ISO format.
Time : HH:MM:SS,
Dates : YYYY-MM-DD,
Example
HExecuteQuery(MyQuery, MyConect,hQueryWithoutCorrection, "'00:00:03'")
HExecuteQuery(MyQuery, MyConect,hQueryWithoutCorrection, "'1970-07-01'")