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/94178.aspxThu, 07 Nov 2013 18:21:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94178wilkies0106aw0https://www.infopathdev.com:443/forums/thread/94178.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94178<p>&nbsp;http://www.infopathdev.com/forums/p/25144/87127.aspx</p><p>&nbsp;This is something I&#39;ve done quite a bit. I end up using SP 2010 calculated columns. As I have to do a fair amount of reporting based on the data entered into a particular form.&nbsp; Here is one way that you could do it - http://tamalijs.wordpress.com/2011/03/10/sharepoint-calculated-date-fields/.</p><p>Also - http://bobbyspworld.com/2013/05/31/calculate-fiscal-year-using-workflow/ <br /></p>https://www.infopathdev.com:443/forums/thread/94175.aspxThu, 07 Nov 2013 17:38:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94175amydpp0https://www.infopathdev.com:443/forums/thread/94175.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94175I have a form that needs to calculate the last two numbers of a fiscal year based on Today. This is the the standard FY that runs from Oct 1 to Sep 30. Any ideas? I am creating a unique number based on other factors and so far have this concat(FACTSCode, OpDivCode, double click to insert field) - and, you guessed it, the double click is where the date formula would go.