I prefer
ldDate = DATE(m.dmryearpick,01,01)
SET FILTER TO dmrr >= m.ldDate
and with your code
SET FILTER TO dmrr >= CTOD("01/01/"+ALLTRIM(STR(m.dmryearpick,4))>SET FILTER TO dmrr >= "01/01/"+ALLTRIM(m.dmryearpick)
>
>dmrr is a date. This is giving me a syntax error. m.dmryearpick is a 4 digit year. Anyone know what the correct syntax for this command should be?
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
