Forum Discussion

clteh9's avatar
clteh9
Helper I
2 years ago
Solved

Sorting chart by date

'DAY' will be displayed as X-axis in a chart but the 'DAY' is not sorted by date correctly.  DAY = format(table1(EXIT_DT],"dd/mm/yyyy")   Current display: 01/04/2023, 01/05/2023, 01/06/2023..... ...
  • clteh9's avatar
    clteh9
    2 years ago

    To add on

    - to sort 'Date name' by 'Date number' and sort 'Month name' by 'Month number'