0

Formula to sort month

Hi Fred. Need to sort the graphic from Jan to Dec, the data is in the Gastos table (the gray data).

I try this but don't work 

select Gastos order by month(this.Mes)

3 replies

null
    • Ninox developper
    • Jacques_TUR
    • 7 mths ago
    • Reported - view

    "Mes" is the name of the month. So, they are sorted alphabetically. Try using Month# for sorting:
    select Gastos order by month(this.Month#)

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths ago
      • Reported - view

       Hi Jacques not work  (select Gastos) order by month(this.'Month#')

      The Month# formula is correct:   month(Fecha_Gasto)

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths ago
      • Reported - view

      now is OK Jacques Thanks. 

Login to reply

Content aside

  • Status Answered
  • 7 mths agoLast active
  • 3Replies
  • 52Views
  • 2 Following