CODEWITHSUNDEEP
datefiltervisidata
Tytire Recubans
Tytire Recubans

Reputation: 997

how to filter rows in VisiData based on date column

I want to filter the rows in my table based on the date. These are the commands I performed:

go to date column, set as key, !, cast to date format @. Click z| and type date < "2021-12-01".

But 0 rows were selected. How do I perform this action?

Upvotes: 1

Views: 921

Answers (1)

aborruso
aborruso

Reputation: 5708

If you have

id,date
1,2020-12-05
2,2020-07-08
3,2024-12-05

open it and set date as date using @, then z| and then something like date > datetime.date(2020,8,8)

Upvotes: 4

Related Questions