Retrieve Month from text

[#1]

Good evening,

I I have to retrieve month from text column . The column is labelled

'ValueJan'

'ValueFeb'

'ValueMar'

..

...

..

and soo on.

How I can correctly retrieve the month ?

[MarcoWedel]

You might also have to set your LongMonthNames variable to your local month names to make the Date#( ... ,'MMMM') approach work.

regards

Marco

[MarcoWedel]

another one:

Subfield(YourField, 'Value', 2)

regards

Marco