you can do this way also create a forumula noofdays as following :
if (month(today) in [1,3,5,7,8,10,12]) then
31
else if (month(today) in [4,6,9,11]) then
30
else if (month(today) = 2 and remainder(year(today),2) = 0) then
29
else
28;
replace today with table field name (date field)
Edited by Savan - 30 Sep 2008 at 5:14am