Forum Discussion
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. ...
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.
Can you provide sample data?
Sounds to me like you should create a new custom column where you standardize the format of the month.
This is from two different table...
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.