Month name change

[knightwriter]

Hi All,

Quick and easy one for you! I have the months of the year as list box properties. My months are showing as Jan-14, Feb-14 etc, how do I change this to show Jan, Feb etc without manually changing all these in my excel spreadsheet.

Many thanks,

Stephen

[senpradip007]

Try this

Date(Date#('Jan-14','MMM-YY'),'MMM')

[ashfaq_haseeb]

Hi,

May be like this.

=left('Jan-14',3)

Regards

ASHFAQ

[Anonymous]

Try this:

In the script

Month(Fieldname)

[tresesco]

I recommend: =Month(Date#(YourField , 'MMM-YY'))

This gives you output which is responsive to all date functions.

[knightwriter]

Hi tresesco,

Where do I use this formula? The script or excel?

Thanks

[Anonymous]

In the Script level...