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.