Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Yes, this is what I need, Thank you