Hi,
You can use the daysBetween function to count days between two dates.
eg.
daysBetween($Entity/StartDate, $Entity/EndDate)
Hi Mavitha,
You can find the answer here:
https://docs.mendix.com/refguide/between-date-function-calls/
Go Make It
Take a look at the daysBetween function.
https://docs.mendix.com/refguide/between-date-function-calls/#6-daysbetween
This returns a decimal value, so if you aren’t interested in the fractions you will probably want to make sure you wrap the two dates with the trimToDays function so they both work from the start of their respective days.
https://docs.mendix.com/refguide/trim-to-date/#5-trimtodaysutc
I hope this helps.