PERIOD_DIFF

rmbourne · 2024-03-20T09:29:55+00:00

There was an error rendering this rich post.

Hi,

I wonder what the problem is with my formula. The end date is March 2024 and the start date is December 2023, but I'm getting 24291 as a result, while I was expecting 3.

Based on the documentation period_diff will return the number of months between two periods.

Is there anything I'm missing here. Thanks

Find more posts tagged with

Beast Mode

Accepted answers

MichelleH

@rmbourne It looks like you are missing the % sign at the beginning of your second DATE_FORMAT function, so your second date is not being properly converted to a date

All comments

MichelleH

@rmbourne It looks like you are missing the % sign at the beginning of your second DATE_FORMAT function, so your second date is not being properly converted to a date

rmbourne

Oh, I overlooked that one. Thanks for pointing that out. I thought there was something that I didn't understand in that function. Thanks @MichelleH

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of