topic Re: Date format change? in QlikView

Date format change?

Thu, 07 Aug 2014 11:57:50 GMT

Hi I have one date column year in my excel data

Apr 2014

June 2014

July 2014

Now i want to cnvert this into date format like Apr-2014

please help me on that.

Re: Date format change?

simenkg — Thu, 07 Aug 2014 12:01:50 GMT

Date(MonthYear,'MMM-YYYY')

Re: Date format change?

tresB — Thu, 07 Aug 2014 12:04:05 GMT

If your this date field is not a proper date field, you might have to try like:

Date(Date#(YourDateField, 'MMM YYYY'), 'MMM-YYYY') as NewDate

And yes, now I note that your date format is not uniform, somewhere three-letters;somewhere four-letters for month. They are expected to be uniform with three-letters.

Re: Date format change?

ashfaq_haseeb — Thu, 07 Aug 2014 12:04:50 GMT

Hi,

try below

Date#(MonthYear,'MMM-YYYY')

Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')

Regards

ASHFAQ

Re: Date format change?

jagan — Thu, 07 Aug 2014 12:04:53 GMT

Hi,

Try like this

=Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')

Regards,

Jagan.

Re: Date format change?

Thu, 07 Aug 2014 12:07:11 GMT

Hi ,

iam not getting any data as per your expresson

actually the data is not in date format.

first i need to change

Jan 2014

Apr 2014

above data into date format

is there any way to change above data into date format

Re: Date format change?

jagan — Thu, 07 Aug 2014 12:09:32 GMT

Hi,

Date() and Date#() function to convert the date format, refer my previous post for solution.

Regards,

Jagan.