Form template: End of month selection in a date picker

This video is a demonstration of an InfoPath form template with a date picker that automatically displays a date for the end of the month.

InfoPath does not have an end-of-month function you can use to automatically calculate and set the value of a date picker to be equal to the date for the end of a particular month.

However, you can use a combination of rules, conditions, and a secondary data source to perform date calculations (that take leap years into consideration) to arrive at a date for the end of a month when a user selects or enters a particular date in a date picker control on an InfoPath form.

The following video is a demonstration of an InfoPath form template that implements such functionality. The form template is available for download by InfoPath 2010 Cookbook customers in the InfoPath 2010 Cookbook Club or by InfoPath 2013 Cookbook customers in the InfoPath 2013 Cookbook Club.

See more InfoPath 2013 tutorial videos »

 
 Subscribe for updates via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services