Skip to main content

In my base, I have 2-tables. The first table contains all of my primary data—the second table with additional data related to my first table.


In table-1, I have a column named “month number”, which means a number will represent a month; i.e. 2 = February or 12 = December etc.


It looks like this:


Month Number

1

5

8

9


In table 2, I have a column named “Month”, with all the months of the year in their own lines.


Example:

JAN

FEB

MAR


Next to that column, I have a column named “Month Number.” Which obviously resulted in having numbers 1 to 12, next to the months of the year.


In my first table, next to the column named “Month Number” I’ve added a column called “Month_Name”. In this column, I want the column to identify that a number represents a specific month name and fill in the column with the corresponding name.


For example:

If 4 = APR, then I want APR to appear in the “Month_Name” column next to it’s “Month Number” column.


So it will look like this:


Month Number

4


Month_Name

April


Your help will be highly appreciated.


Thanks

This can be done without a second table. Turn the {Month_Name} field into a formula field using the following formula:


DATETIME_FORMAT(DATETIME_PARSE({Month Number} & "", "M"), "MMMM")


Reply