Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date sorting

Hi,    I'm hoping someone can tell me why I can't sort the date AU column by the Date Sort column? I've managed to do sorts like this before, but suddenly it won't work... :(   Thank you!   Son...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yuta-msft

 

Thanks for your reply. 

 

Yes, that's the error I get! Unfortunatly I can't  find a solution in that thread either... 

 

How should I go about ranking this column so the dates display in order?

 

Thanks again, 

Sonia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Is your date column in date format? It looks like Text. Could you change the format in the modelling tab and try gain?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous, 

     

    The column is formatted as Date/Time, but it's still not working 

     

    Any other ideas?

     

    Thank you!

     

    Sonia