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

[krishna20]

Hi ,

Please find the below attachment and guide me to find another ways to resolve this.

Regards

Krishna

[ashfaq_haseeb]

Hi Krishna,

Check this

Regards

ASHFAQ

[MarcoWedel · Accepted solution]

Hi,

the reason for the behaviour you experienced is that you already loaded your month_fullnames as a date field formatted as month fullnames. So the proposed solutions using the Date# function didn't find a string to interpret as a date (that's what the #-functions do).

On the other hand this means, that your front end expression

=Month(Date(Month_FullNames,'MMM'))

can be abbreviated to

=Month(Month_FullNames)

as the formatting date() function is useless in this case, it does not change the underlying numerical value of your Month_FullNames field (Ret_Month).

Using this expression

Date(Date#(SubField('$(MonthNames)',';',MONTH),'MMM'),'MMMM') as Ret_Month

to create your Ret_Month field in the script leads to somewhat weird underlying numerical values:

because you are trying to create a complete date value from only a month field (the year information is missing) and then just formatting it to show month fullnames.

I therefore stick to my proposed solution

Dual(Date(Date#(MONTH,'MM'),'MMMM'), MONTH) as Ret_Month

which creates these underlying values:

like one would expect from a real month field.

If you wanted to create the month shortname field in the script, then one solution could be:

Month(Date#(MONTH,'MM')) as Ret_Month_short

hope this helps

regards

Marco