DAYS

[sagaraperera]

Dear All

I have a two field in pol_policy_from_date and pol_policy_to_date. I want a calculate no of days how to do this.

sahara

[shiveshsingh]

By simply subtracting two dates you get the the difference in days.

=pol_policy_from_date -pol_policy_to_date, will give you the difference in days.

[fallenangel6]

i always convert days to floor and then do such manipulations.

floor(pol_policy_to_date)-floor(pol_policy_from_date)