https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123537.aspxWed, 07 Oct 2020 21:09:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123537Froman0https://www.infopathdev.com:443/forums/thread/123537.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123537this is exactly it, thanks so much Hilaryhttps://www.infopathdev.com:443/forums/thread/123532.aspxWed, 07 Oct 2020 13:58:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123532Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123532.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123532If you just want to add years, I'd think using substring functions would do the trick. You could use substring-before the first hyphen to get the year, then add to that, then substring back together. See the attached sample form. Right click the linked file and save locally. Right click the saved file and select Design to open in Design mode. Then preview to try.https://www.infopathdev.com:443/forums/thread/123529.aspxTue, 06 Oct 2020 19:43:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123529Froman0https://www.infopathdev.com:443/forums/thread/123529.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123529Is there a way to add years to infopath dates? I've got an expiry date, and I'm lookind to add years to it an save in another field. Is there a way to do this between sharepoint designer and infopath? Thanks