topic Re: Exclude dates in App Development

Exclude dates

brucemeyers — Thu, 15 Nov 2018 00:16:58 GMT

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

Re: Exclude dates

sunny_talwar — Thu, 15 Nov 2018 00:59:51 GMT

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

Re: Exclude dates

brucemeyers — Thu, 15 Nov 2018 01:19:01 GMT

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

Re: Exclude dates

dathu — Thu, 15 Nov 2018 01:21:47 GMT

Are you comparing months? what is your requirement?

Is your date field have proper date format?

Re: Exclude dates

Thiago_Justen_ — Thu, 15 Nov 2018 01:38:43 GMT

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)

Re: Exclude dates

jonathandienst — Thu, 15 Nov 2018 05:24:35 GMT

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.