topic The problem with the format of date values in QlikView

The problem with the format of date values

Mon, 26 Jan 2026 18:19:17 GMT

Good day! please tell me how to fix the problem. Access to the data is imported on request with the value of "Month" is displayed in numeric format, for example, "6", "7" When you select "Date" in the format MMM in "Numbers" is displayed the month of January, regardless of the query result.

query:

SQL SELECT

[id_ЦП]

, [Дата]

, month([Дата]) as [Месяц]

,[Платежи, грн]

,[Количество]

,[Вид]

FROM `VIEW_Платежи_`;

why in January, rather than in June (6)?

Thank's for any help

Re: The problem with the format of date values

ashfaq_haseeb — Sun, 22 Jun 2014 13:28:31 GMT

Hi, I don't understand field names properly.

assuming that [Дата] is a date field, try below.

query:

Load * ,month([Дата]) as [Месяц];

SQL SELECT

FROM `VIEW_Платежи_`;

Hope it helped.

Regards

ASHFAQ

Re: The problem with the format of date values

Sun, 22 Jun 2014 13:38:51 GMT

Yes, this is what I need, Thank you