topic Re: Date format, full month name in QlikView

Date format, full month name

Fri, 05 Dec 2014 15:56:01 GMT

Hi,

I'm loading data with the following date format: September 19, 2014

I've tried the below in qlikview, the result looks good, but is still not recognized as a date.

DATE# (LEFT(Right(DateField,8),2) & '/' & Left(DateField,3) & '/' & Right(DateField,4), 'DD/MM/YYYY') As Date

Any ideas?

Kind REgards,

Olle

JonnyPoole — Fri, 05 Dec 2014 16:21:11 GMT

If the format looks good, try wrapping it in a Date() function. Date# is for interpretation of source data, Date is for formatting.

Date(DATE# (LEFT(Right(DateField,8),2) & '/' & Left(DateField,3) & '/' & Right(DateField,4), 'DD/MM/YYYY')) As Date

marcus_sommer — Fri, 05 Dec 2014 16:27:20 GMT

The string-operations aren't neccessary:

=date(date#('September 19, 2014', 'MMMM DD, YYYY'), 'DD/MMM/YYYY')

- Marcus

Fri, 05 Dec 2014 16:28:52 GMT

HI,

Please follow the below link. Its an excellent post on dates and dates interpretation.