Afternoon All,
I have a Date Column with the format YYYY-MM-DD but Alteryx will not filter on it. I thought this was the correct date format?What have I missed?
Example data attached
Thanks
I think you've updated your formula, and it should work now if you change the -1 to -3. But again, the dataset doesn't contain any data from the last 3 days so you won't get any results.
Hi @Bobbins
You're filtering to 2023-02-21, but the max date in your data set is 2023-01-22
If you change your filter to 2023-01-21 then you get data out:
Hope that helps,
Ollie
It is the correct date format and your filter works fine, you've just chosen a date that doesn't exist in your data! I've just changed the month from Feb to Jan
*Facepalm* Thank you @Christina_H & @OllieClarke Well that answers one problem, but are you able to get this to work? Because it doesnt for me but i am guessing i could be missing something again?[Date] >= DateTimeAdd(DateTimeToday(), -1, "days")Thanks
Is that for the filter again? You're asking whether a date is later than three days before itself, and all dates will return true. What are you trying to do?
@Christina_H I am trying to filter for the last 3 days
Trying to use the suggested Alteryx help from here and using this code: DateTimeAdd(DateTimeToday(), -1, "days") should return yesterday’s date according to help
I forget, I am in February, keep thinking I am still in January!Sorry @Christina_H
No worries @Bobbins, we all have days like that!
