Calculation for days between 2 dates

user048760 βšͺ️

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!


Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀
    Accepted Answer

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

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