Filter only dates by month yyyy-mm-dd in a drop down list box RRS feed

  • Question




      I'd like to filter my Employed Date drop down list box to show maybe "February" or maybe 2012/02 as choices.

    Users would select the month and all the records with an employed date within that month would return! 

    That sounds so fun and easy huh!!

      I really appreciate your time and insight.

      Thank you,


    Wednesday, March 14, 2012 6:52 PM


  • Hi Jeff,

    You can create a Calculated type column and calculate the month and year from Employed Date like this article.

    Use the formula =TEXT([Employed Date],"mmmm") to get the month

    Use the formula =TEXT(YEAR([Employed Date]),"000") to get year, 

    Or combine them like this  =TEXT([Employed Date],"mmmm")&"/"&TEXT(YEAR([Employed Date]),"000"),

    Then you can filter this Calculated column by month.


    Daniel Yang

    TechNet Community Support

    Friday, March 16, 2012 6:40 AM