BE2010 Allocated Date issue

[MyLee]

I want sorting by date from newest to oldest. but after I clicked Allocated Date, it sorted by another way. could someone help me about this?

We have two media servers and the other one was working well.

thanks  in advance.

[Colin_Weaver]

Complete correction of my previous answer (just in case you saw it before I removed it)

The Correct example does not list any media allocated at 10:xx PM or  11:xx PM on the same date as something allocated in the morning as I think you would see the problem on the "correct" server as well if it did.

Basically it seems to be sorting by the first digit of the hour indicator and ignoring the AM / PM settings

Hence something allocated at 11:00 PM is being listed before something allocated on the same day at 08:00 AM which is clearly wrong..

You could try setting 24 hour clock which would probably fix it as a workaround (my server is set as 24 Hour clock currently)

EDIT: It could be worth you setting the time format to AM or PM - but the format that puts leading zeroes in the hour fields (so hh:mm:ss t) as another possible option for a workaround