How to get first and last day of the current month?

Hello, I am super new at Metabase (version: 0.29.3) and I am just wondering is there any change to get first and last day of the current month with native query? I am expected keywords like current_date for it, but not able to find it something similar.

Hi @bullception

0.29.3 was released in May 20018 - current version is 0.31.2 released in December 2018.

When using the Native Query, then you’re using whatever language your database talks, so you need to check your database manual (or search the internet).
I.e. the way to get first/last day of month with MySQL is different from MongoDB.

1 Like

Wow, that’s totally my misunderstand :man_facepalming: You are right :blush:. Thank you.