topic Re: Dates using wrong language?? in QlikView

Dates using wrong language??

Anonymous — Wed, 08 Jun 2016 06:53:31 GMT

Hello folks,

I have a weird scenario that has me stumped. I have developers in Mexico who are co-developing and application with me. For some reason, when I format a date to show the full month name (for example) the month is in Spanish. This does not appear to happen in all of the files they have co-developed. Does anyone have any insight?

The SET environment variables are as follows:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Thanks,

Mike

Re: Dates using wrong language??

sunny_talwar — Wed, 08 Jun 2016 09:31:14 GMT

Try adding this to your environmental variable:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Re: Dates using wrong language??

Anonymous — Thu, 09 Jun 2016 00:29:23 GMT

Thanks Sunny. That resolves the issue. I'm not sure why this even happened in the first place. Typically LongMonthNames and LongDayNames is not needed.