Date Range Syntax

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

@Benn_Bennett

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!

@Benn_Bennett

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

1 Like

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.

@Benn_Bennett

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