Number of days between 2 dates

Hi team,
I want to get the number of days between the current date & the date in a table.

I checked that i can use datediff, but by default it only provides the difference of Days.

For e.g If i use date diff on 8/15/2023 & 7/2/2023, the result would be 13, whereas what i want is the 44.

Is there any way or custom way in which i can do this?

Any help would be highly appreciated.


Hi @Abhishek_Singh,

Can you show a screenshot of your calculation?

Hi @Abhishek_Singh

Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 7 days, we will archive the question