month and year picker

Posted on 2009-12-29
Last Modified: 2012-05-08
hi , i need a month and year picker  not a normal date picker , ve to use in jsp to pick only month and year
thanks in adv
Question by:inickinfosystems
    LVL 17

    Accepted Solution

    Returns the month for date, in the range 1 to 12 for January to December, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero month part.
    mysql> SELECT MONTH('2008-02-03');
            -> 2

    Returns the year for date, in the range 1000 to 9999, or 0 for the zero date.
    mysql> SELECT YEAR('1987-01-01');
            -> 1987
    LVL 6

    Expert Comment

    Display two combo boxes in your picker div or small popup window. and assign the selected combo box values to your parent window using opener object (like opener.document.forms[0].yourtxfiled=document.forms[0].monthCombobox.selected)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now