
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
as per the format '31/08/2015', using
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')
will be better option...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change
Date($(Max Date Selected))
to
Date($(Max Date Selected), 'MMM-YYYY')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Also try,
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or if this is permanent change.
Go to your variable and change the format there.
Feeling Qlikngry?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Just change the expression to Date#($(Max Date Selected),'MMM-YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
as per the format '31/08/2015', using
Date(Date#($(Max Date Selected),'DD/MM/YYYY'),'MMM-YYYY')
will be better option...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
