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

  • Question

  •  

    HOwdy!

     

      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,

     Jeff

    Wednesday, March 14, 2012 6:52 PM

Answers

  • 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.

    Thanks


    Daniel Yang

    TechNet Community Support

    Friday, March 16, 2012 6:40 AM
    Moderator