Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Filed

Hi all,

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

1 Solution

Accepted Solutions
Not applicable

Re: Date Filed

thry this

=monthname(date) as monthyear

hope this will helps you

8 Replies

Re: Date Filed

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

Hope it helps

Re: Date Filed

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.

Not applicable

Re: Date Filed

thry this

=monthname(date) as monthyear

hope this will helps you

Not applicable

Re: Date Filed

Hi,

Use

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

HTH

-Shruti

Re: Date Filed

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

or

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

Not applicable

Re: Date Filed

Else try this

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

ashwanin
Valued Contributor

Re: Date Filed

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

vipin_mishra479
Contributor II

Re: Date Filed

Hi Kannuri,

try This One

 

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

Vipin

Community Browser