Bin dates in SQL question

1

Hia,

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?

Thanks!

Simple question
image

SQL question
image

2

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