topic Re: Format Date in QlikView

Format Date

Wed, 25 Nov 2020 16:16:04 GMT

I want to show just the first 3 letters of each month but when I use monthname show the intere name of the month.

I try to use Date(date, 'MMM/yyyy') and is also showing the entire name of the month.

There are some setting I have to change?

Thanks in advance.

sunny_talwar — Tue, 08 Mar 2016 18:36:34 GMT

Make sure you have this in your load script:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Tue, 08 Mar 2016 19:05:14 GMT

Thank you