Figured it out. Here's my working code:
#include "sbasic_include.sbas"
var vDateInitial as String
var v1stHalf as Date
var v2ndHalf as Date
var vDate as String
var vHandle as Int
var vPrint as String
//Takes user input from the Date field in the Work Subform in however format they type it and converts
it to the Sesame system dating of yyyy/mm/dd so that it works as a search spec with @XResultSetSearch.
vDateInitial = @FormFieldValue("Work", "Work_Date", 0)
v1stHalf = @Del(vDateInitial, @Instr(vDateInitial, ".."), 10)
v2ndHalf = @Mid(vDateInitial, @Instr(vDateInitial, ".."), 10)
vDate = v1stHalf + ".." + v2ndHalf
//Imports the search spec into the result set search and assigns an RS Handle.
vHandle = @XResultSetSearch(@FN, "ACTION!Work", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!LE0=" + vDate)
//Prints the result set within the RS Handle if the form is in Update mode.
If(vHandle > -1)
{
vPrint = @XResultSetPrintReport("Techs Receivable", vHandle, REPORT_MODE_HTML_PREVIEW)
}
//Closes result set.
XResultSetClose(vHandle)
It turns out there were a couple things wrong that weren't working.
Yes the security was the number one issue, and why I continually got "-1". Even though I never had to enter a username or password to do anything with the database, there were still security settings that were set that needed to be removed.
But also, it wouldn't work using "Work_Date" as the name in @XResultSetSearch(), I did indeed have to use "LE0" which is the original name that it was assigned to, which is interesting because I thought I remember reading that you only have to use the original bound to names for XLookUp commands.
Anyways, the other key thing that was wrong was the format of the search criteria in @XResultSetSearch(). It turns out you can't enter a date range like you can in the main form for a date field. You know where you might enter something like "2/1/18..2/28/18." This is what it wants instead: "2018/02/01..2018/02/28. Essentially yyyy/mm/dd. So if you convert it to that then, it will work perfectly.
Thanks for all the help everybody, now to make the report look better.