Results 1 to 2 of 2

Thread: [CLOSE][CR 8.5]How convert data format to YYYY only

  1. Aug 29th, 2007, 01:21 AM #1
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    [CLOSE][CR 8.5]How convert data format to YYYY only

    Hi all,

    I have a report contains a field in date format

    Example : 21 / 08 / 2007

    I would like convert it to "mmm/yyyy"

    I use the code in edit formula like this

    Code:
    
	
     'VB' Code:
    
	
    1. MonthName(Month({Table.Date1}),True) & " / " & year({Table.Date1})
    However, my return format is : Aug / 2007.00
    How can i make it return format = Aug / 2007


    Your help is much appreciated. Thanks you
    Last edited by nUflAvOrS; Aug 29th, 2007 at 03:18 AM.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
  2. Aug 29th, 2007, 01:31 AM #2
    nUflAvOrS
    nUflAvOrS is offline

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Re: [CR 8.5]How convert data format to YYYY only

    Sorry for double thread, please help me to close thread.
    thanks you
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width