Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write a script to show the date format

Hi all,

I am new to use qlikview to build some reports and now have a question about the date formating as follows:

- How to write a script in the Edit Expression box to show the date format like "Aug-2015", instead of "31/08/2015"

Best Regards,

Alan

1 Solution

Accepted Solutions
ahbzshk07
Contributor III
Contributor III

as per the format '31/08/2015', using

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

will be better option...

View solution in original post

6 Replies
oknotsen
Master III
Master III

Change

Date($(Max Date Selected))

to

Date($(Max Date Selected), 'MMM-YYYY')

May you live in interesting times!
tamilarasu
Champion
Champion

Also try,

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

robert_mika
Master III
Master III

Or if this is permanent change.

Go to your variable  and change the format there.

Feeling Qlikngry?

How To /Missing Manual(24 articles)

Anonymous
Not applicable
Author

Hi,

Just change the expression to Date#($(Max Date Selected),'MMM-YYYY')

ahbzshk07
Contributor III
Contributor III

as per the format '31/08/2015', using

Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')

will be better option...

oknotsen
Master III
Master III

I noticed you "liked" my reply.

If that means your question is answered, please flag the correct answer as Correct Answer (and optionally flag helpful answers as Helpful).

If not, please let us know what question you still have about this topic .

May you live in interesting times!