range where with sqldate

[bolsen]

I am trying to range where the equivalent of the following tsql code:

select * from rm00101 where CCRDXPDT <= '2010.02.28' (date field on the current window)

my range where statement from a window pushbutton:

local string AAACutoff;

if not empty('(L) AAACutoffDate') then
AAACutoff = sqlDate('(L) AAACutoffDate');

range clear table RM_Customer_MSTR;
range table RM_Customer_MSTR where physicalname('Credit Card Exp Date' of table RM_Customer_MSTR) + CH_SPACE + CH_LESSTHAN + CH_EQUAL + CH_SPACE + AAACutoff; {sqlDate('(L) AAACutoffDate');}

fill window AAACCUpdateList table RM_Customer_MSTR;

I get no data returned where the tsql, of course, does. I have tried wrapping the date in single quotes, using a local variable to avoid context issues, and read every pass through blog (David Musgrave's mostly) I can find with no luck.

Are these sqlDate and CH_ commands documented somewhere? The code is much more elegant than the dex equivalent but only if it works...

TIA

 

[bolsen]

Looks like I needed to wrap the date in SQL_FormatStrings(). Go figure.