Does anyone know the correct syntax for showing a date range in a table with rows which contain a date column? Specifically, I want to only show rows that have a date within a specific month (e.g. March) that are not blank (because some are blank and shouldn’t show up).
Have you tried the Month() or MonthName() formulas in a Filter() statement?
1 Like
I did, but when I explored the filter guide (https://coda.io/formulas#Month), nothing gave me a range of dates. Everything wants one specific day. I’m trying to display all the dates from 3/1/19-3/31/19 (for example). I tried playing around with >2/28/19AND<4/1/19 and no luck there either. I’m good at copying correctly implemented formulas, but obviously not at making them from scratch!
Here are some examples I just tested:
thisTable.Filter([date column].MonthName() = "March")
thisTable.Filter([date column].Month() = 3)
I’ll check back in later today to see where you’re at.
Hi @Benn_Bennett,
Please check out this sample doc:
Hopeful this is what you want?
Best regards,
//JP
2 Likes
That did it, thanks! I guess I had to create another row that produced a specific month and then reference that row. I did try the formulas by @Ander, but couldn’t get them to work without creating an additional “reference” row.
Here’s how you combine those steps. Study the formula in the blue column, which can also be applied in the Table filter editor.
1 Like