Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Date(Date#('Jan-14','MMM-YY'),'MMM')
Hi,
May be like this.
=left('Jan-14',3)
Regards
ASHFAQ
Try this:
In the script
Month(Fieldname)
I recommend: =Month(Date#(YourField , 'MMM-YY'))
This gives you output which is responsive to all date functions.
Hi tresesco,
Where do I use this formula? The script or excel?
Thanks
In the Script level...