Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try Like this
month(Date#(Monthname_Full,'MMMM'))
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
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)
Hi,
Check this
Regards
ASHFAQ
Check this
Hi,
this solution could look like:
hope this helps
regards
Marco
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
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
can you post your solution in a sample app?
thanks
regards
Marco
Hi,
Can you post sample application to look over.
Regards
ASHFAQ