Months full names to short Names

[krishna20]

Hi Friends,

i'm having the Month_FullName as a field. How can i get short names from this filed.

for e.g; January, February, March...........   to Jan , Feb, Mar, Apr.......

Please suggest how to do it.

Regards

Krishna

[Kushal_Chawda]

Try Like this

month(Date#(Monthname_Full,'MMMM'))

[krishna20]

Hi all,

Thank you for your valuable suggestions.

I need the expression like if(Month_FullNames=Month(Date#(Month_FullNames,'MMM')), Month_FullNames).

expected result like.

I need to write this expression in list box to show like above.Please suggest me how can i get it.

Regards

Krishna

[Kushal_Chawda]

Hi,

you can create a field as below

month(Date#(Monthname_Full,'MMMM')) as MonthName

Now call this MonthName in Lisbox and sort by Numeric (In Sort Tab of Properties)

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[anbu1984]

Check this

[MarcoWedel]

Hi,

this solution could look like:

hope this helps

regards

Marco

[MarcoWedel]

When loading your Month_FullName field, you should take care that it is loaded as a dual value, i.e. you don't have to implement additional sorting expressions for this field at front end:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

tabMonths:
LOAD Dual(Month_FullName, Month(Date#(Month_FullName,'MMMM'))) as Month_FullName
Inline [
Month_FullName
January
February
March
April
May
June
July
August
September
October
November
December
];

hope this helps

regards

Marco

[krishna20]

Hi ,

Thanks to everyone who suggested me.Finally i got output with the expression =Month(Date(Month_FullNames,'MMM')).

Many of People has suggested me to try =Month(Date#(Month_FullNames,'MMM')).

But It Doesn't Works out. I don't know what is the Difference between Date and Date # and why Date# function hasn't work in my application.

Thanks to all once again.

Regards

Krishna

[MarcoWedel]

can you post your solution in a sample app?

thanks

regards

Marco

[ashfaq_haseeb]

Hi,

Can you post sample application to look over.

Regards

ASHFAQ