Calculation for days between 2 dates

Golfoholic

I have a dataset that has 2 dates auction date and last payment date, both are in the same format "2021-06-03 05:00:00 AM" I am trying to write a beast mode that will count the number of days between the last payment date and the auction date. I struggle with any date statements, any help would be great!

MarkSnodgrass

You can use the DATEDIFF function. You would write it like this:

DATEDIFF('Last Payment Date' , 'Auction Date')

MarkSnodgrass

You can use the DATEDIFF function. You would write it like this:

DATEDIFF('Last Payment Date' , 'Auction Date')