MonthEndRed.gif (2426 bytes)
More Info on MonthEnd
  • View a sample program that shows how this unique calendar control works (included with the product)
    • Use Month End to construct SQL statements
  • From/To Dates
  • Cross-Tab, Pivot Tables
  • Properties/Events
  • Forecast/Budget
  • Back-End uses
  • Limitations
  • Price/Purchase
  • Bill Me







    Month End is a different kind of calendar control that lets users activate month begin and month end dates with a minimum of clicks. It doesn't pop up a whole lot of calendars, with a bunch of date dates or buttons, make users go back and forth between years, or do any of the difficult tasks that all calendar controls require. It just sits there. It doesn't change.

    Why does selecting two dates have to be so difficult?

    This is what Month End looks like:

    monthendcontrol.bmp (16986 bytes)

    That's all it is. It doesn't change, except if you give it different begin and end months and years.

    Who can use it:

    Month End is a Visual Basic ActiveX calendar control. Programmers place it in an application and   get beginning and ending dates for selected months. It's intended to be used in reporting applications.

    It can also be used as an Internet control (IIS only), or in Excel, Access, or any application that can use ActiveX controls.


    Left-click for From-Month value (like Jan 1, 2003)

    Right-click for To-Month value (like Aug 31, 2003)

    Double-click to get one month FROM - and - TO dates

    The year drop-down relates to ToDate. Whatever is the year, that's the year of ToMonth. Think about it. You really don't NEED to know what the year of FromMonth is if you know the year of ToMonth.

    The program will NOT allow you to select dates outside of your range.No errors appear to disturb your users, the control just KNOWS what you want, and re-adjusts itself accordingly.

    The control exposes the month NUMBER  of the values you selected. Like, if your data goes from Oct 1, 2002 through Dec, 2004, that's 27 months. If you select May, 2002 through Feb, 2003, the control returns  8 through 17. This is great for programs that summarize all data in months by column, or in a back-end program. Help tells you how to calculate dates with Month End.

    As you cross years the calendar adjusts itself to accommodate what you mean. If you select ToDate as Feb, 2002, then right-click on  Dec, the control KNOWS that you mean Dec, 2001, so it re-adjusts the year drop-down.

    More Info on MonthEnd

    Back to MiniSolve Products

    Tips on Visual Basic, SQL Server, Crystal Reports, JD Edwards, more

    minisolve_logo_small.gif (3681 bytes)