return the value text name

[Anonymous]

Hi,

I've got a dual Field Month.

I need to set an expression which returns a text value which corresponds to a particular numeric value.

Say, I've got number X.

I'd like to set a function which returns the text value of X.

Is it possible?

Thank you in advance,

Larisa

[#2]

You mean 'Ten' for the number 10?

[Kushal_Chawda]

Please elaborate more on the requirement

[Anonymous]

No, I mean 'October' for the number 10.

The field Month is dual. So, every month has got its number.

[Anonymous]

Each value of the Field month in dual.

So if I set number 1 the expression shoul return 'January',

if I set number 2 the expression shoul return 'February' and so on.

[sasiparupudi1]

=date(makedate(year(today()),10),'MMMMM')

[antoniotiman]

You have dual field if in Your Script You have

Month(Date) as Month

if Date is a valid date field.

Month is Dual field

[Anonymous]

Actually, I've got several dual fields.

one is Month, another is Media (each media has got its own text and numeric value).

Is it possible to solve the task for the Media field as well?

[Kushal_Chawda]

Create the Month using Date field

Date(YourDateField,'MMMM') as Month

Create the inline table to assign number

load * inline [

MonthNum, Month

1, January

2, February

3,March

4,April,

5,May

6,June

7,July

8,August

9,September

10,October

11,November

12,December ];

[krishna_2644 · Accepted solution]

See attached.