>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?
set filter to dmrr >=date(m.dmrYearPick,1,1)
Are you sure you want to go with SET FILTER at all? There may be better alternatives.
If it's not broken, fix it until it is.
My Blog