The problem with the format of date values

[#1]

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

[ashfaq_haseeb · Accepted solution]

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

[#3]

Yes, this is what I need, Thank you