torin3 Member Joined Dec 25, 2004 Feb 26, 2007 #1 I need to set the default value for a form to one year before the current date. It is set now for the current date with: =Date$() What would be the syntax to change it to one year ago?
I need to set the default value for a form to one year before the current date. It is set now for the current date with: =Date$() What would be the syntax to change it to one year ago?
OP torin3 Member Joined Dec 25, 2004 Feb 28, 2007 Thread Starter #2 Any suggestions on maybe a book or some other source I could search?
OP torin3 Member Joined Dec 25, 2004 Mar 13, 2007 Thread Starter #3 =Now()-365 I knew it was simple