Skip to main content

⚠️ Please note that this topic or post has been archived. The information contained here may no longer be accurate or up-to-date. ⚠️

Sort by name

Henrik Lorenzen
Help
this is driving me maddddddddd
i have a lot of albums named 2016 01-08 (and then a name) like 2016-01-08 Horse show so the 1 of august
then I have 2016-31-07 Show jumping
so when I sort by date it should be
2016-31-07
2016-01-08
but it is not
it looks like it is shorting by day not the Date what the heck am I doing wrong here
0

Comments

8 comments

Date Votes
  • John Doe
    2016-3xxxx comes /after/ 2016-0xxxx in ASCII order.

    You should name your folders YYYY-MM-DD, not YYYY-DD-MM.
    0
  • Henrik Lorenzen
    ahh thanks
    not that it makes sense but now I know
    0
  • John Doe
    It does make sense if you realise that your computer has no way to know that 2016-01-30 means a date to you. To your computer, it's simply a sequence of numbers, so it sorts your filenames accordingly as if they were words in a dictionary: 2016-01-xx comes /before/ 2016-31-xx, because the 0 in sixth place is < 3.
    0
  • Christian Gruner
    [quote="Lorenzen" wrote:
    Help
    this is driving me maddddddddd
    i have a lot of albums named 2016 01-08 (and then a name) like 2016-01-08 Horse show so the 1 of august
    then I have 2016-31-07 Show jumping
    so when I sort by date it should be
    2016-31-07
    2016-01-08
    but it is not
    it looks like it is shorting by day not the Date what the heck am I doing wrong here


    You being in Denmark, where YYYY-MM-DD is standard, why use the (mostly) American way in the first (just curious)?
    0
  • Henrik Lorenzen
    Christian
    If I remember right it started back when I used Aperture 1 on a Mac setup to us Keyboard and date
    it is a left over and something is hard to change 😊
    0
  • SFA
    [quote="Lorenzen" wrote:
    Christian
    If I remember right it started back when I used Aperture 1 on a Mac setup to us Keyboard and date
    it is a left over and something is hard to change 😊


    One of the great confusions of the computer age!

    In a database, if a field is defined as a date type, the "date" is actually just a string of numbers (in effect) which gives a serial number for date and time that is relatively consistently used although there are some differences about the start date for the numbering.

    Software looks at the string, checks which numbering system is in use and how the date should be displayed locally on the device and shows it accordingly. Internally the date string is just counting days from a known starting point so works with YYYYMMDDHHMMSSss etc.

    Once you have used the date in its text form - whichever style you may choose - it is just text to the computer as has already been mentioned.

    So your folders and file names are text.

    In C1 of you sort by Date that will be the file date (for example) and will be defined as a Date Type field.

    I doubt that is likely to be useful to solve your requirement. There is probably a relatively painless way to fix the folder naming (and file naming if you have applied the same rules to part of the file name) but it may cause confusion with reference to an already processed shoots.

    HTH.


    Grant
    0
  • Henrik Lorenzen
    Cheers Grant
    i will guess I have to change all the dates no big deal now I know what the issue is and how to fix it
    Henrik
    0
  • SFA
    Henrick,

    If you have named the files the same way you may be able to use the Batch Rename features to "fix" them.

    Just a thought.


    Grant
    0

Post is closed for comments.