Case to change from date format to month 1

[choochoowinn2009]

Hi,

I need to write a formula to change from date format xx/xx/xx to month format such as Jan, Feb, etc...

How would you write that case?

Thanks,
C

 

[lbass]

monthname(month({table.date}),true)

-LB

 

[choochoowinn2009]

How would you then change the date to MONTH YEAR as in Jan 1999?

 

[lbass]

monthname(month({table.date}),true)+" "+totext(year({table.date}),"0000")

-LB