Monday, November 28, 2011

How to find date difference in SharePoint 2010 Infopath.


Expression to Find the Age based on D.O.B:



(substring(today(), 1, 4) - substring(DOB, 1, 4)) - 1 * (translate(substring(today(), 6, 5), "-", "") < translate(substring(DOB, 6, 5), "-", ""))