Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia,
Tenho esse campo abaixo:
=(Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM'))
Porém na ordenação da listagem fica errada conforme imagem
É possível classificar pra ficar sequenciado conforme calendário?
The field values are text, and the list is alphabetically sorted, which is correct.
If you want to sort it numerically, you need to create the field values as duals, e.g.
=Dual(
(Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM')),
Floor(WeekStart(VENCIMENTO))
)
The field values are text, and the list is alphabetically sorted, which is correct.
If you want to sort it numerically, you need to create the field values as duals, e.g.
=Dual(
(Date(Floor(WeekStart(VENCIMENTO)), 'DD-MMM'))& ' - ' & (Date(Floor(WeekEnd(VENCIMENTO)), 'DD-MMM')),
Floor(WeekStart(VENCIMENTO))
)
It worked out! Thank you very much