https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/64866.aspxMon, 07 Mar 2011 09:42:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64866Patrick Halstead0https://www.infopathdev.com:443/forums/thread/64866.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=64866<p>Have you looked at the addDays xpath function? You could do something like addDays(today(), -1) to get yesterday.</p>https://www.infopathdev.com:443/forums/thread/64861.aspxMon, 07 Mar 2011 07:15:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64861srinatha0https://www.infopathdev.com:443/forums/thread/64861.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=64861What are the codes for days, months, years? How can I subtract on day from the current date Today()