Date Filed

[#1]

Hi all,

I have date field as 1/1/2013,MM/DD/YYYY. now i want to show it as jan-13

[alexandros17]

Cast date field as Date(myDate, 'MMM-DD')

Hope it helps

[Colin-Albert]

use date(monthstart(myDate), 'MMM-YY')

The monthstart will make all dates in January 13 be based on the same date, if you just change the format of the Date value without monthstart, the text will show as MMM-YY but the data will hold the individual date values.

[#4 · Accepted solution]

thry this

=monthname(date) as monthyear

hope this will helps you

[#5]

Hi,

Use

Date(monthname(myDate),'MMM-YY')

HTH

-Shruti

[MK_QSL]

=Date(Date#('1/1/2013','MM/DD/YYYY'),'MMM-YY')

or

=Date(Date#(YourDateField,'MM/DD/YYYY'),'MMM-YY')

[#7]

Else try this

=monthname(Date(num(Date#(YourDateField,'MM/DD/YYYY')),'MM/DD/YYYY'))

[ashwanin]

=DATE(Datefield,'MMM-YY') as DateField

[vipin_mishra479]

Hi Kannuri,

try This One

=date(MonthName( date(Today(),'MM/DD/YYYY')),'MMM-YY')

Vipin