What is a Beast Mode to calculate days and months between dates?

kim_barragan0126 · 2025-04-08T17:27:22+00:00

There was an error rendering this rich post.

I am trying to calculate days between dates; Current Date and Start Date. I need the length of assignment in days, and then eventually months.

I am using the below Beast Mode, but my Length of Assignment in Days is off. The current date is 4/8/2025 for all, but I cannot figure out what the problem is. Any ideas?

Find more posts tagged with

Accepted answers

ColemenWilson

Yep! Values are doubling because you are summing them. Switch to MIN or MAX to fix

All comments

ColemenWilson

Bizzarre. Try:

DATEDIFF(CURRENT_DATE(),StartDate)

I am using your data and getting the correct results. Can you share what your card setup looks like in analyzer view? Curious to see the sorting and filters you are using.

kim_barragan0126

That doesn't work either. I also tried the below. And I made sure my Date columns were not strings. Maybe I need to go to support?

DATEDIFF(Current Date,StartDate,'DD')

ColemenWilson

Can you share what your card setup looks like in analyzer view? Curious to see the sorting and filters you are using.

kim_barragan0126

Does this help?

For the company name, I have selected one company, and the Match Status is Full Placement. The other filter is removing any matches that have ended already.

I have removed the names for confidentiality.

ColemenWilson

Yep! Values are doubling because you are summing them. Switch to MIN or MAX to fix

kim_barragan0126

So easy! Thank you!!!!!!