Effective dated quires are used often in PeopleSoft and a great build-in function that will save you time is the %EffDtCheck. Lets take a closer look!

The %EffDtCheck construct expands into an effective date subquery suitable for a Where clause.

recordname: Specify the record name to use as the record in the effective-date checking. This can be bind variable, a record object, or a record name in the form recname.
correlation_id1: (Optional) Specify the letter used inside the effective-dating subselect. If this parameter isn’t specified, recordname is used.
correlation_id2: Specify the letter already assigned to the main record in the From clause of the SQL statement.
as_of_date: Specify the date to use in the effective date. This can be a bind variable, a variable, or a hard-coded date. The value for as_of_date is automatically wrapped in%DateIn unless as_of_date is already wrapped in %DateIn or refers to other database columns.

Here is some SQR to help you validate a date format.  You can modify the code to fit your own needs and date format you desire.

_{!-------------------------------------!}
! Procedure: Date-Validation          !
! Descr:     Validate $entered_date.  !
!-------------------------------------!
Begin-Procedure Date-Validation
#debug show 'Entering Date-Validation'

Let $Date_Validation = 'N'
!Show '$entered_date: ' $entered_date
Let #1st_Slash_position = instr($entered_date, '/', 1)
!Show '#1st_Slash_position: ' #1st_Slash_position
Let #2nd_Slash_position = instr($entered_date, '/', #1st_Slash_position + 1)
!Show '#2nd_Slash_position: ' #2nd_Slash_position

Here is some SQR code that will open a file for reading:

Begin-Procedure Open-File
#debug show 'Entering Open-File'

!file name and where it is located.
Let $new_file = $PATHNAME || 'your_file_name.txt'
Show '$new_file = ' $new_file
!check if the filel exists before trying to open it
Let #estatus = exists($new_file)
If #estatus = 0
Show 'Log File ' $new_file ' exists. Will be opened for reading.'
!opening file for reading
Open $new_file As 1 For-Reading Record=3000
Status=#FileStat
!couldn't open file if #FileStat is not zero
If #FileStat <> 0
Move 'N' To $file_open

So I've activated the Related Items Module in Joomla and noticed that It doesn't have an option to limit the number of related items or articles to display. Well, this could be such a big problem for large websites. Imagine a page that has over 100 related articles displayed on it! It is sure going to be one heck of a long long page.

I was able to hack into the helper.php file located in modules\mod_related_items\ and modify the code to limit the number of related items display or even better, specify how many articles I would like to display.

And this is what I've done: