where statement in variable

[thomaswrieck]

Hi,

maybe a stupid question ... I want to store a Where clause in a variable and use it when calling a subroutine ...

LET vWhereCM = 'Vehicle.CheckInDate>=' & chr(39) & '06/01/2008' & chr(39);

That is what I have currently but the string then results as :

.

.

.Resident Summary WHERE Vehicle.CheckInDate>=''06/01/2008''

What do I need to specify to get :

Resident Summary WHERE Vehicle.CheckInDate>='06/01/2008' ?

Thanks a lot for a tip ...

Thomas

[sunil2288]

HI Thomas U can try

Resident

Summary WHERE Vehicle.CheckDate<''06/01/2008'' or Vehicle.CheckDate=''06/01/2008''

[brenner_martina]

Hi, Thomas,

I would prefer to use the num-function for dates, than you don't need quotes for numbers, here the variables would be like this:

New variable for numeric date:

LET vNumDate = Num(Datefield); or LET vNumDate = Num(Makedate(2008,1,6));

LET vWhereCM = 'Num(Vehicle.CheckInDate)>=' & $(vNumDate) ;

[thomaswrieck · Accepted solution]

great .. thanks a lot ... that one worked for me ...

LET vNumDate = Num(Makedate(2008,1,6));

LET vStartDate = 'Num(Vehicle.CheckInDate)>=' & $(vNumDate) ;