Dates to Months?

[knightwriter]

Hi All,

I have a query on how I get all the dates (shown below) to show as a selection month. Any help is much appreciated.

Best,

Stephen

28/06/1999 to show as a June etc

[PrashantSangle]

Hi,

USe

MonthNAme()

or

Month()

Regards

[PrashantSangle]

Hi,

Try

Date(DateField,'MMMM')

Regards

[#4]

hi,

not so clear but you can use date function

Date(date,'DD/MMM/YYYY'-   28/JUN/1999)

Date(date,'DD/MM/YYYY')

date('28/06/1999','DD/MMM/YYYY') as Date

date(Today(),'DD/MMM/YYYY'),

month(date(Today(),'DD/MMM/YYYY'))

month(Today())

Regards

Vimlesh

[rajkumarb]

hi

Stephen

use this

Month(yourdatefield) As Monthname

Month( Date#( yourdatefield,'MMM') ) as Monthname,

[knightwriter]

Hi max dreamer,

Thanks for the but where do I put MonthNAme()?

Cheers

[PrashantSangle]

Hi,

If you are trying it in script.

Like

MonthName(DateField) as MonthYear

Month(DateField) as MonthNumber

Date(DateField,'MMMM') as MonthName

Regards

[buzzy996]

use this,

Month(urdatefield) as Month

[knightwriter]

Hi All,

Many thanks for all your replies. I am not familiar with editing the scripts, is there a way I can do this in the multi box properties? 

[PrashantSangle]

Hi,

In MultiBox->Add as Expression

->MonthName(Activity.Duration)

->MonthName(Activity.External)

and so on

Regards