Get period date


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


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