I am working to piece together my understanding of the SELECT statement in Ninox.

REQUEST 1:  Does anyone have a few examples where they use the 'Join()' command? I'd like a few working examples.

REQUEST 2: And maybe this is an easy one, but I can't figure out the use of dates in the select statement. Here are x examples and the results:

-example 1

(select Timesheet where 'check-in date' = today() and volunteerid = 5).volunteerid.'full name'

result:  retrieves the 'full name' from the volunteer table navigating the volunteerid relationship. Result given:  Steve Hill

-example 2

let v := this;
(select Timesheet where 'check-in date' = today() and VolunteerID = v).VolunteerID.'Full Name'

result:  again, retrieves the currently selected 'full name' from the volunteer table navigating the volunteerid relationship but using variable v. Result given: Steve Hill

-example 3

let d := today();
let v := this;
(select timesheet where 'check-in date' = d and volunteerid = v).volunteerid.'full name'

result: returns nothing. No error on script. No result.

same if I enclose in double quote.

However, if I change it to (select timesheet where 'check-in date' = date(d) and volunteerid = v).volunteerid.'full name'

then it works. Slow return, but it works. I can't figure out why I'd need a date format on the variable to get a result.

How should it work?