Filter sales this month.

[Ruben_Rossvold]

This will be a long post, and a intricate task because Airtable somehow in 2023 doesn't have a "date is current month" type of filters.

I want to in my interface dashboard to summarize the total sales value within the current month. And in a statistics summary show the total sales pr month.

The rightmost box is is currently filtering the sales done within a month ago, which is not the correct setup.

When it's april, that one should only display April sales, not anything from March.

I have already a formula field that declares the date the sale was done, which is the field called "Salg".

What i need the formula to do is to return "1" or "true" if it's this month.

And then i will filter the summary to only calculate the sales value on the records which are a match to whatever value we create in the formula.... 

I appreciate any help i can get here.

[FlywheelConsult]

Here's how I do it:

IF(MONTH(TODAY())=MONTH({Salg}),1,0)

[RdMedia_srl]

you can use this formula

IF( MONTH({Salg}) = MONTH(NOW()), 1,0 )