topic Re: Date format in QlikView

Date format

QSense — Wed, 05 Sep 2012 13:43:46 GMT

Hello ,

I have date field its format:DD-MM-YYYY HH:MM

I want to make format such WeekStart-WeekEnd like 19 Jan 2012 - 26 Jan 2012

Wed, 05 Sep 2012 14:07:44 GMT

Below format conversion should help:

=Date(WeekStart(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY') & ' - ' & Date(WeekEnd(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY')

Replace Now() to your [Date Column]

Note: The output will be a String and no longer be treated as a Date

jonathandienst — Wed, 05 Sep 2012 14:30:54 GMT

You can simplify this (where DateField is the field on which the expression is based, and is a valid date):

=Date(WeekStart(DateField),'D MMM YYYY') & ' - ' & Date(WeekEnd(DateField),'D MMM YYYY')

Regards

Jonathan

jonathandienst — Wed, 05 Sep 2012 14:33:07 GMT

As vigi-baba said, this will be a string. If you want this expression to sort properly by date, you could use a dual value:

Dual(Date(WeekStart(DateField),'D MMM YYYY') & ' - ' & Date(WeekEnd(DateField),'D MMM YYYY'), WeekStart(DateField))

Regards

Jonathan