topic Re: Date Filed in QlikView

Date Filed

Wed, 29 Jan 2014 09:59:47 GMT

Hi all,

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

Re: Date Filed

alexandros17 — Wed, 29 Jan 2014 10:01:07 GMT

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

Hope it helps

Re: Date Filed

Colin-Albert — Wed, 29 Jan 2014 10:10:24 GMT

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.

Re: Date Filed

Wed, 29 Jan 2014 10:14:10 GMT

thry this

=monthname(date) as monthyear

hope this will helps you

Re: Date Filed

Wed, 29 Jan 2014 10:20:37 GMT

Hi,

Use

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

HTH

-Shruti

Re: Date Filed

MK_QSL — Wed, 29 Jan 2014 10:21:38 GMT

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

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

Re: Date Filed

Wed, 29 Jan 2014 10:26:08 GMT

Else try this

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

Re: Date Filed

ashwanin — Wed, 29 Jan 2014 10:38:13 GMT

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

Re: Date Filed

vipin_mishra479 — Wed, 29 Jan 2014 10:42:53 GMT

Hi Kannuri,

try This One

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

Vipin