Filtering date greater than current year

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

Developer

Date Time

Accepted answers

NickSm

@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.

All comments

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.

DateConvert1.yxmd

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?

ATX1.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703