Sort by name
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
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
-
2016-3xxxx comes /after/ 2016-0xxxx in ASCII order.
You should name your folders YYYY-MM-DD, not YYYY-DD-MM.0 -
ahh thanks
not that it makes sense but now I know0 -
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 -
[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 -
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 -
[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.
Grant0 -
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
Henrik0 -
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.
Grant0
投稿コメントは受け付けていません。
コメント
8件のコメント