• View "By Date" shows time with hours > 24

    By Thilo Hamberger 2 decades ago

    This problem arises when time is already in military format. Then the conversion doesn't work (hours get always a +12). I also doubt the sorting works since the date part gets converted into text.



    Solution: Just split it into two columns, one with date and one with time.

    • Thanks, good point about the date

      By Chad Schelfhout 2 decades ago

      The problem with two columns is the second does not categorize correctly. If you have an example of this working then please post the steps here or email me.



      I look at the Date and the military time issue.

    • needs to be one

      By Chad Schelfhout 2 decades ago

      have two colums does not group the documents correctly. I have tried but was not successfull with two columns. If you can please let me know.