Date Formula (Month)

[Anonymous]

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

[v-ljerr-msft]

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. 

Regards

[Greg_Deckler]

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]

This is from two different table...

[Greg_Deckler · Accepted solution]

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.