topic Re: Date format in App Development

Date format

antupe — Wed, 27 Apr 2022 11:56:48 GMT

Hello! In the dashboad that I am creating I import data from an excel file that cannot be edited. In my graphs I show the date in the format DD-MMM-YYYY, but it is being displayed in Spanish (because the data imported from excel is in Spanish). I tried changing the environment variables so that the English version would show, but when I do so the date is no longer displayed in the graphs. Apparently Qlikview does not recognise the date field in Spanish if the environment variables are in English... Any idea of how I could import the date field (that is in Spanish) and display it in English?

Thank you

Re: Date format

Or — Wed, 27 Apr 2022 12:37:53 GMT

If the date is an actual date field in Excel, it's not in any language - it's actually numeric and language shouldn't be a problem.

If the "date" in excel is actually a string of text, the quickest workaround is probably to just replace the month part using a match statement. I don't know the month names in Spanish but for English it'd be along the lines of:

MakeDate(Right(Date,4),Match(Mid(Date,4,3),'Jan','Feb','Mar'),Left(Date,2)) // Note - type in all 12 months, not just the three, and as they appear in the file

Re: Date format

antupe — Fri, 29 Apr 2022 09:57:16 GMT

Thank you!