Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Filter not working

becki
8 - Asteroid

if i set a date filter to "use start date and include subsequent periods after that date" and set period definition to years and number of periods as 3, and filter on a date field, i only get the data for the start date (in this case 10-1-2018) .  if i try "start and end dates", i get the same.  what am doing wrong with the date filter?  thanks

 

becki kain

 

7 REPLIES 7
becki
8 - Asteroid

also, if i just use the filter command with [field1]>="2018-10-01", i get the same result

Thableaus
17 - Castor
17 - Castor

Hi @becki 

 

Could you share a sample of your data? Just the Date Field, at least.


Cheers,

becki
8 - Asteroid

2018-10-01 where it is :

 


SAR023_PROCESS_DATE_Y Date 10 File: (Multiple Sources)

and even with a plain filter of:

[SAR023_PROCESS_DATE_Y]>="2018-10-01", i get just that date's data and not all. thanks

 

Thableaus
17 - Castor
17 - Castor

@becki 

 

This is inconclusive. We'd need to see a file with a sample of your data.


Cheers,

becki
8 - Asteroid

thanks

Thableaus
17 - Castor
17 - Castor

@becki 

 

Worked fine here. Bringing correct dates (from start date and until 3 years after).

 

Workfine.PNG

 

Cheers,

becki
8 - Asteroid

it must be a function of my data.  I'll try another angle.  thanks

 

Labels