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

kim_barragan0126 · April 8

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?

ColemenWilson · April 8

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

ColemenWilson · April 8

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 · April 8

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 · April 8

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

kim_barragan0126 · April 8

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 · April 8

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

kim_barragan0126 · April 8

So easy! Thank you!!!!!!

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

Best Answer

Answers

Categories