where statement with two criterias

[chriys1337]

Hello,

I would like to load some fields between two dates and I am not sure, if the where statement is correct.

Can somebody please support?

Resident Calc_AUX where [Calc.month code] >=$(vL.month_min3) <=$(vL.month_completed);

Or do I need to add a "and": Resident Calc_AUX where [Calc.month code] >=$(vL.month_min3) and [Calc.month code]<=$(vL.month_completed);

[Anil_Babu_Samineni]

Second statement is valid. You can use this?