Exclude dates

[brucemeyers]

For some reason this syntax 

where month([Date])>=month(today())

is not excluding these dates

12/01/2014
11/30/2016
12/30/2016

the dates below are the only ones I should see.  Can you help?

11/01/2017
11/01/2018
11/02/2018
11/04/2018
11/05/2018
11/06/2018
11/07/2018
11/08/2018
11/09/2018

[sunny_talwar]

Would you be able to share a sample where this is happening?

[brucemeyers]

In a load statement after the from script (referring to a connection and file) in the data load script 

[dathu]

Are you comparing months? what is your requirement?

Is your date field have proper date format?

[Thiago_Justen_]

Just test this:

where Date([Date],'MM')>=month(today())

Also check if the variable DateFormat in the main section is ok.
Set DateFormat='M/D/YY'; //(US format)

Set DateFormat='DD/MM/YY'; //(UK date format)

Set DateFormat='YYYY-MM-DD'; //(ISO date format)

[jonathandienst]

Month(today()) = 11 and the three dates you mention have month values of 11 and 12. So the syntax you mention would not exclude those dates.

I think you need a year condition or month-year condition to exclude dates for November and December of earlier years.