Showing posts with label How to find date difference in SharePoint 2010 Infopath.. Show all posts
Showing posts with label How to find date difference in SharePoint 2010 Infopath.. Show all posts

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), "-", ""))