Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
Solved

Help sorting column order

Hello,   Hoping you can help, might not have done this correctly but here's where I am. I  have two date columns, start and end. Shown as i.e 01 Feburary 2015. In then needed to change the format ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi rosscortb 

    It could not work when you sort the same value[Start Date and End Date] by different values[Start Date].You may use sort by 'Start Date Mon' as below green part.

    Regards,
rosscortb's avatar
rosscortb
Post Patron
7 years ago

Yeah, wouldn't let me use Start Date.

 

HotChilli's avatar
HotChilli
Community Champion
7 years ago

Ah, fine.  Error messages are usually helpful.

The message says it doesn't know how to sort because start date is not unique 'enough', that is, the same start date exists for different 'start and end date' values.

So you need to find a way of making it unique, maybe add a calculated column (number) to sort by, constructed from the 'start and end date' field like yyyymmdd from start date and append yyyymm  from end date.  Just an idea, i haven't tested it.