Monthname 1

[Zbob]

When using the monthname function how do you abbreviate?

 

[goranm]

Hi !

If it´s ok with you, you can instead of monthname use the ToText-function like this:

ToText({table.datefield,'MMM') will give you an abbreviate monthname

and

ToText({table.datefield,'MMMM') will give you the full monthname

/Goran

 

[synapsevampire]

Purdy slick there, Goran!*!

I always used: left(monthnae(month({MyTable.MyDate})),3)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Zbob]

Thanks for your help,

What i wanted is monthname([date]),True)

the true is what makes it abbreivate.

 

[Naith]

Huh? That formula works?

 

[Zbob]

Actually monthname returns the month for a number 1-12, I was using it like this

MonthName (Month(date(01/01/2002 )),true )

 

[synapsevampire]

Ahhh, didn't know about the switch on the monthname, I still now prefer ToText({table.datefield,'MMM').

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com