Range of dates

[SimonaAlex]

Hello all,

I'm new here 🙂

I was trying to filter on two dates to have a range of dates biyt was not able to do so.

Can you please advise whant Am I doing wrong here?

Thanks a lot

[JosephSerpis · Accepted solution]

Hi @SimonaAlex alteryx only recognises dates as a date Type if it in the format YYYY-MM-DD. Therefore if you want to work with dates or find a range in your example then you need to work with Date fields. If you change the filter to conditions to work with data field then it work as expected. I amended your workflow to showcase this.

[SimonaAlex]

Morning Joseph

Thanks a lot for your explanation

[ll98]

I also have a similar request -- but I do have a data extract where it pulls the GL Date -- but I need to group these dates into quarterly reporting periods.  For example, 

1/1/2020 - 3/31/2020

3/31/2020- 6/30/2020

7/1/2020 - 9/30/2020

10/01/2020 - 12/31/2020

but this report has like a 10 year history.....

Any advice