You can simply format your original date field to display only the month name.
In a calculation, you can use this: MonthName(datefield)
I'm trying to extract the month and day from a UK formatted date field.
For example, 26/01/2008 needs to result in 01/26 (with leading and trailing zeros)
I tried using the following calculation but it doesn't work in all cases:
Month ( start_ar ) & "-" & Day ( start_ar )
Google just found this thread for me - and it still works perfectly in FM11. Cheers.
Brian Curran - we seem to have a mix of postings here, but if you still need an answer to your question:
Month ( start_ar ) < 10 ; 0 & Month ( start_ar ) ;
Month ( start_ar )
& "/" &
Day ( start_ar ) < 10 ; 0 & Day ( start_ar ) ;
Day ( start_ar )
Thanks Sorbsbuster, that works great!