2 Replies Latest reply: Jun 22, 2014 9:38 AM by dvdgd dgdg RSS

    The problem with the format of date values

      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