Get period date

Hi,

I installed the latest version of Metabase and saw the period functionality.
For example, when I filter using :

"value":"past1months",

To retrieve last month data.
My question, is it possible to extract the date of the period?

Hi @Exe
Your would have to use something like concat(year(), month(), day()) together with datetimeSubtract()
https://www.metabase.com/docs/latest/questions/query-builder/expressions-list
And then you'll do that twice for first and last period.

How do I use it ? Inside my SQL query ?

@Exe Then you should probably start out by saying that you're using SQL and Field Filters instead of showing screenshots from the GUI.
Have a look here: Date range filter for custom field - #2 by flamber