Forum Discussion

ML999's avatar
ML999
Regular Visitor
8 years ago
Solved

Sort x-axis by date (MM/YYYY) for three years

Hi,   I am having issues with sorting my data in ascending order from 01/2015 to 09/2017. I have tried to use the "sort by column" feature but it does not work. Please see below. My ideal date form...
  • thomasronn's avatar
    thomasronn
    8 years ago

    Add a new column with year and monthnumber (YYYYMM) to your table and use that for sorting

thomasronn's avatar
thomasronn
Icon for Resolver I rankResolver I
8 years ago

Add a new column with year and monthnumber (YYYYMM) to your table and use that for sorting

  • SachinC's avatar
    SachinC
    Icon for Helper V rankHelper V
    6 years ago

    You mean like this: DateInspectedTXT = year([DateInspected])&month([DateInspected]) ?