Calculation for days between 2 dates

Golfoholic
Golfoholic βšͺ️
in Card Building

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!

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·
    Answer βœ“

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

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



    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories