topic Re: Converting a date to text in QlikView

Converting a date to text

Wed, 23 Jan 2013 13:39:13 GMT

Do anybody know if there is an expresion that will convert a date to text? For instance Jan-2013 to Jan?

Wed, 23 Jan 2013 13:43:12 GMT

Hi,

if your field value is 'Jan-2013' you can use the Left() function.

Left(Field,3)

Hope it helps

Regards

Giampiero

Wed, 23 Jan 2013 13:59:32 GMT

suppose your date field from where you get Month Year as Jan-13 is Date then create a field MonthNumber in ur script;

num(Month(Date)) as MonthNumber

Now u can create an inline table in ur script:

Load * Inline

[

MonthNumber,MonthName

1,Jan

2,Feb

3,Mar

4,Apr

5,May

12,Dec

];

jagan — Wed, 23 Jan 2013 14:00:48 GMT

Hi,

Left('Jan-2013', 3) is the best option to get the month name.

Regards,

Jagan.

hic — Wed, 23 Jan 2013 17:13:55 GMT

Using Left() will work, but you will not be able to sort the months properly. Use the following instead:

Month(Date#(DateField,'MMM-YYYY'))

HIC