topic Re: Format Date in QlikView

Format Date

Mon, 06 Feb 2017 02:33:56 GMT

My date is in the form of 31/01/2017. I want to format it as 31-Jan. How do I do it?

This doesn't work. There is an error.

=date(date#(=maxstring({[Date1]} [DATE]),'DD/MM/YYYY'), 'DD-MMM')

sunny_talwar — Mon, 06 Feb 2017 04:24:13 GMT

May be this:

Date(MaxString({[Date1]} DATE), 'DD-MMM')

UPDATE: or this

Date(Max({[Date1]}Date#(DATE, 'DD/MM/YYYY')), 'DD-MMM')

tresB — Mon, 06 Feb 2017 04:30:20 GMT

Did you try like?

Date(Date#(yourDate, 'DD/MM/YYYY'), 'DD-MMM')

sdmech81 — Mon, 06 Feb 2017 08:06:45 GMT

=Date(Date#( [DATE], 'DD/MM/YYYY'), 'DD-MMM')