Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors