which three are valid settings for the initial Value = property of the Shipping_Date Item?

Iin an Order Entry form, the Order_Items block has a text item called Shipping Date, which is of
the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not
defined for this item.
Assuming that the following are defined, which three are valid settings for the initial Value =
property of the Shipping_Date Item?

Iin an Order Entry form, the Order_Items block has a text item called Shipping Date, which is of
the Date data type. The Lowest Allowed Value and the Highest Allowed Value properties are not
defined for this item.
Assuming that the following are defined, which three are valid settings for the initial Value =
property of the Shipping_Date Item?

A.
$$DBDATE$$

B.
:Orders.Order_Date + 3

C.
SYSDATE

D.
:GLOBAL.SHIP_DATE

E.
:PARAMETER.SHIP

F.
ORDER_ITEMS_SEQ

Explanation:
A: Use $$DATE$$, $$DATETIME$$, and $$TIME$$ to obtain the local system
date/time; use $$DBDATE$$,
$$DBDATETIME$$, and $$DBTIME$$ to obtain the database date/time, which may differ from the
local
system date/time when, for example, connecting to a remote database in a different time zone.
„ Use these variables only to set the value of the Initial Value, Highest Allowed Value or Lowest
Allowed Value property.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


ngayathri81

ngayathri81

As I have checked, A,D,E is the correct answer. SYSDATE is not a valid value

Padmanabhan

Padmanabhan

Correct Answer: A,D & E