 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / February 2007Function for default value of a date field
I have date field and would like to set its default value to be 6 months prior to today. It appears that the only date functions which I am able to use for a default value are now() and today(). Is it possible to modify the results from the today function such that it returns a date 6 months prior to today? While it is possible, you will get into trouble when your calculated date falls in February or in a month that has 30 days instead of 31. It is best to write code to perform such date calculations. Search this newsgroup on "add days" to find posts on how this can be done. --- S.Y.M. Wong-A-Ton > I have date field and would like to set its default value to be 6 > months prior to today. [quoted text clipped - 3 lines] > results from the today function such that it returns a date 6 months > prior to today? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.