Filtering date greater than current year

[HW3]

Hello, I'm trying to filter by date based on [date] > 09/02/2019 in the filter tool. It filters out the transactions before this date but also its filtering out the dates before '09' (August) in the future. Example 08/07/2020 and 02/08/2021 are also being filtered out. It seems like it is only reading the month and not the day or year. Does this relate to formatting in my source file am I not doing something right? Thank you Horace

[NickSm]

@HW3 

Currently it'll be filtering based on taking it as a string, you'll want it in yyyy-MM-dd format to do date-time filtering.  Can use a date conversion tool pretty easily for that, then your filter should work as planned.  Example workflow attached.

[HW3]

Hi NickSm thanks for replying. What does it mean if my New Date value is coming out as null after using the Date Time tool like you show in your example?

[NickSm · Accepted solution]

@HW3  If you take a look at the settings on the date-time tool, you'll notice that you have to specify what the incoming format is (MM/dd/yyyy for example), and then this will be converted.  If you're getting nulls, the tool probably isn't recognizing the pattern it's set with at the moment.  Feel free to post your sample input dates if you aren't able to get that working.

[HW3]

@Nick Sm that worked. I missed the "incoming string field" part of the equation. I thought it was how you wanted the output to come out. Thanks for the help. Horace