Hi
Can you copy and share the part of the scrip where you load and filter the data?
Did you check if you ended the instruction with a semi-colon?
Generally, the format of a Load / Select script is the following:
//Start of the select instruction
Select *
From YourTable
Where Year(DateSubMitToOpen)>=xxxx and Year(DateSubMitToOpen)<yyyy
;
// End of Select instruction
Another source of the error warning maybe the fact that your field "DateSubMitToOpen" as a timestamp may not be a Date field but a text field instead.
If that's the fact you need to transform this text field in a Date
Can you check that?
