Datediff per month

user046467 · 2021-12-06T12:49:33+00:00

There was an error rendering this rich post.

Hi,

How can I show the datediff per month instead of per day.

I tried the following beastmode:

DATEDIFF(`date1`,`date2`,MONTH())

Can someone point me out what I am missing?

Thanks in advance

Find more posts tagged with

You'll want to use PERIOD_DIFF instead of DATEDIFF:

PERIOD_DIFF

Returns the number of months between months in two date columns. For this to work, the date values must be months in the format YYYYMM.

PERIOD_DIFF('Month 1', 'Month 2')

I would use something like:

period_diff(date_format(`date_stage_changed`, '%Y%m'),date_format(`date_created`, '%Y%m'))

This will get the number of months between two dates without having to make sure they are in the correct format to begin with.

Best,

Nick

What's the data format of the column you're operating on?

I tend to use TIMESTAMPDIFF(month, `date1`,`date2`) in mySQL flows.