How to write a script to show the date format

[#1]

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

[oknotsen]

Change

Date($(Max Date Selected))

to

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

[tamilarasu]

Also try,

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

[robert_mika]

Or if this is permanent change.

Go to your variable  and change the format there.

Feeling Qlikngry?

How To /Missing Manual(24 articles)

[Anonymous]

Hi,

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

[ahbzshk07 · Accepted solution]

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

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

will be better option...

[oknotsen]

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 .