none
Age calculation in Infopath

    Frage

  • Hi,

    I have a textbox field in Infopath 2010. The data in the textbox is filled from sql table from secondary data connection. The textbox gets value as a date field in mm/dd/yyyy format. For example: 12/31/2010.

    textbox field is called Birthdate

    I had tried like this:

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

    But I am not getting the age properly.

    How to calculate the Age based on the texbox field?

    Thank you

    Dienstag, 8. Februar 2011 11:50

Antworten

Alle Antworten