Enter Dates in Oracle Argus Insight Date Fields
Several fields in Oracle Argus Insight are date fields. Some date fields require a full date; other date fields accept a partial date.
- Enter a Full Date:
-
For fields that require a full date, you must enter the date in the following format:
dd-mmm-yyyy
where:
- dd = Day of the month.
- mmm = 3-letter abbreviation for the month, like FEB or
AUG.
You may alos enter a valid month number. In this case, the system converts the number to the 3-letter abbreviation for the corresponding month. For example, the system converts 12 to DEC.
- yyyy = 4-digit year, like 1998 or 2012.
- Enter Today's Date
-
To enter today's date in a date field, press the = (equals) key.
- Enter a Partial Date
-
For fields that accept a partial date, Oracle Argus Insight displays ??-???-0000 in the field.
For reporting purposes, missing days of the month are approximated to the 15th of the month and missing months are approximated to the month of June.
Valid partial dates must comprise either a year, or a year and a month. If you enter the day, you also need to enter the month.
To enter a date that includes only the month and year (like, March 2012), you may enter any one of the following sequences:
- /MAR2012
- /32012
- /312
- 00MAR2012
- 0032012
- 00312
- ??MAR2012
- ??32012
- ??312
To enter a date that includes only the year (like, 2012), you may enter any one of the following sequences:
- //2012
- //12
- 00002012
- 000012
- ?? ???2012
- ?? ???12
- ??2012
- ??12
The following table lists the fields in the tabs on the QUERY BY EXAMPLE page, which is similar to the Oracle Argus Safety case form, that accept partial dates.
Table 2-1 QBE Fields that Accept a Partial Date
QBE Tab Section Name Field Name General
General Information
Study Information
Initial Receipt Date, Central Receipt Date, Follow-up Received, Safety Received, Aware Date
Unblinding Date
Patient, Patient
Patient Details
Date of Birth, Date of LMP
Patient, Patient
Lab Data
Date
Patient, Patient
Other Relevant History
Start, Stop Date
Patient, Parent
Parent Information
Date of Birth, Date of LMP
Patient, Parent
Other Relevant History
Start, Stop Date
Products
Dosage Regimens
Start Date/Time, Stop Date/Time, Expiration Date
Products
Product Details
First Dose, Last Dose, Date, Start Date/Time, Stop Date/Time
Events
Event Information
Onset Date/Time, Receipt Date, Stop Date/Time
Activities
Contact Log
Date, Date Start
Activities
Action Items
Date Open, Due, Completed
Activities
Case Lock/Archive
Lock Date, Closure Date
Parent topic: Get Started