Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use the Where Clause to only select the last two years but keep getting error message.
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?