Building a query with editor needing Today()

Hi -

Trying to build a query with the query editor. I want to put in "Less than or equal to Today()" but the field will only accept a date. Do I have to do this with a parameter? I rather not have to pass the parameter each time - it's always going to be "Today". Is this not possible?

Thanks!

Joel

Check out using WL functions in the 'Calculated Item' section of the Query generator.
I have not tried this sort of thing from there myself!

Failing that then edit the sql code direct (you will lose the graphical query display).
I added the last line of the Select statement and the WHERE clause (in Blue).
Something like the code below should do the trick.
I have not tested this but I do have similar code working.

SELECT 
	MemberMain.idMemberMain AS idMemberMain,	
	MemberMain.MembershipNo AS MembershipNo,	
	MemberMain.DateJoined AS DateJoined,
	WL.DateSys() AS Today
FROM 
	MemberMain
WHERE 
	MemberMain.DateJoined <= Today

HTH
Regards

DerekT