Bin dates in SQL question


I using the simple and custom editor I can bin dates into months.
If I convert these questions to SQL I get:

date_trunc('month', outbound_date)

which works great, but always displays the full date. See below.
Is there some SQL magic I can throw at it?


Simple question

SQL question

Hi @aornugent

It’s because technically it’s getting a full date with Simple/Custom too, but because it knows you’re binning by month, then it visually changes that.

But on Native, it’s still returning a full date, but it doesn’t know you only it to be displayed as month.

Workaround, is to return the date as a formatted string.

1 Like