Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date Formula (Month)

Hello, 

 

I am wondering what formula to use to grab months from a related table? Some tables are in format "July" and others are in the format 07/01/2017.

 

Thanks in advance for your help.

 

CK

Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Create a new column in your first table, "MonthName" or something with a formula like:

     

    MonthName = FORMAT([Date],"mmmm")

    Then you can relate the two tables. Still not entirely sure what you are asking.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Can you provide sample data?

     

    Sounds to me like you should create a new custom column where you standardize the format of the month.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

       

      This is from two different table...

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        9 years ago

        Create a new column in your first table, "MonthName" or something with a formula like:

         

        MonthName = FORMAT([Date],"mmmm")

        Then you can relate the two tables. Still not entirely sure what you are asking.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    I'm not I can understand your requirement either. Could you post your table structures with some sample/mock data, and the expected result? So that we can better assist on this issue. :smileyhappy:

     

    Regards