none
How to use formulas in calculated value field in InfoPath Form

    Question

  •  

    In the above Infopath2010 form i want to use the given below formula......at result of Totaldays field(with 'calculated value' data type).

    Formula:

    =IF(AND((WEEKDAY([End Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([End Date],2)))>1),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2)-2),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2)))

    please someone help me to get that.Thanks in advance

     

     

     

     


    Charles Michel.B Lead Consultant Mobile:+91 9659730405 www.itbusinessnetworks.co.uk
    Tuesday, October 18, 2011 5:14 PM

Answers

All replies