Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Date Filtering - Converting Dates To Months

Hi all,   I want to create a Date Filter drop down which has a list of the months.   I have a column with dates in. How can I create a date dropdown which then only sows the months and will retur...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi HenryJS ,

     

    We can create a calculated column use Format function to meet your requirement:

     

    MonthSlicer = FORMAT([Date],"MMMM")

     

     

     

     


    If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

     


    Best regards,

     

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi HenryJS ,

 

We can create a calculated column use Format function to meet your requirement:

 

MonthSlicer = FORMAT([Date],"MMMM")

 

 

 

 


If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

 


Best regards,