https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/27723.aspxSat, 05 Apr 2008 03:29:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27723Clay Fox0https://www.infopathdev.com:443/forums/thread/27723.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=27723<p>Welcome to the forum.</p> <p>If you search here on Datediff you will find some sample vbscript to do this.</p> <p>There is no date calculation function in InfoPath but this is the next best thing.</p> <p>You can calculate the date one year from the last year date.</p> <p>If you would like to see an example send me an email.</p>https://www.infopathdev.com:443/forums/thread/27722.aspxFri, 04 Apr 2008 23:59:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27722Alchemist610https://www.infopathdev.com:443/forums/thread/27722.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=27722<p>Hi Good People,</p> <p>I am new to Infopath and found it very useful. But I need some help. I am displaying information from a database in infopath 2003.</p> <p>In one column, I am entering Training Date of Employees with a date picker. But employees need to go on this training on a yearly basis. I have another </p> <p>Column where Training Status is Displayed as OK or DUE TRAINING.</p> <p>Can I have this done automatically with Infopath? DUE TRAINING must be automatically displayed after one year of training date.</p> <p>If so please advice.</p> <p>Thanks very much.</p> <p>&nbsp;</p>