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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft 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