community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Showing all records with a date older than a specified date

Atom

Hi,

 

I'm wondering if there's a way to show all records that have a date older than a specified date? In this case, older than 01/01/2018? So in the below example Products A, B and D should show up.

 

I tried a custom filter [Production Creation Date(UTC)] < "01/01/2018  00:00:00", but only Product D showed up...

 

  Product Description

 Product Creation Date(UTC)

A

12/18/2006 00:12:25

B

12/19/2017 01:09:32

C

03/19/2019 01:09:32

D

 

01/01/2017 23:58:40

 

Thanks!

Fireball

Have you converted your date/time field into an actual date/time data type, or is it still in string format? When I convert from string to date/time and filter to dates less than 2018-01-01 I get products A, B and D as expected.

Atom

 on my part, I used the date/time function to convert the format.

Fireball

@GP2 Maybe try tweaking your filter language to [Production Creation Date(UTC)] < "2018-01-01" then? If it's in date/time format then that should get you what you need. If that still doesn't work then would it be possible for you to share your flow or an example of it so I can help troubleshoot further?

Labels