PDA

View Full Version : Date order photos



cs
01-27-2017, 12:00 PM
I'm always taking pictures of jobs for work and saving them on the server at work. Always keep them in a folder that is titled by the date, 27 Jan 2017, so we can back later and have chronological job progress record.

Okay when browsing pictures I end up with a list of folders that are labeled by date but the order is either alpha/numeric or date modified order. I would like to see these in a true chronological order when I browse the folder so I can just start at the top and go down in true order without having to jump around.

To accomplish this I'm thinking of starting each folder name with the Julian date and then the traditional date. For example instead of a folder being named 27 Jan 2017 I would name it 7027 27 Jan 2017. That way when ordering it alpha/numeric it would be in a true chronological order when browsing.

Does this make sense? Any better suggestions?

Chad

Canoez
01-27-2017, 12:05 PM
We used to have an application which used the digital information from the camera to organize the photos by date in a digital "album" on the computer. It did portions of that automatically. We still had to label the pictures, grouping them by "job". I don't recall what the software was, but it was simple, intuitive and user-friendly with many view options for information and photos.

I'm sure that Emily or someone else can make a recommendation.

CWSmith
01-27-2017, 12:05 PM
2017-01-27

Norman Bernstein
01-27-2017, 12:05 PM
One alternative is to use hyphenated dates, like 1-27-2017, which will order themselves.

Edited to add: CWSmith's suggestion is even better: 2017-1-27

cs
01-27-2017, 12:11 PM
For some reason that simple solution just plumb evaded me. A classic case of overthinking. LOL For so long I've done my dates in the ddmmmyyyy format that completely forgot about the above mentioned solution. Maybe I just wanted a good reason to use Julian Dates. :d

Chad

Jimmy W
01-27-2017, 12:49 PM
The software for my camera saves them as 2017_01_27.

Norman Bernstein
01-27-2017, 12:58 PM
For some reason that simple solution just plumb evaded me. A classic case of overthinking.

We all do it, Chad.

About a year ago, I was in an informal conference with my client (BS and MS degrees in engineering) and another co-worker, similarly educated. We were trying to solve an incredibly simple equation, the familiar 'y=mx+b' equation of a straight line, based on sample points on the line... and we played on the white board for at least 20 minutes, and couldn't come up with the solution....

....the light bulb finally went off, in my head, 20 minutes later.

There are NO problems so simple, that a person can't eventually stumble on one of them :)

willmarsh3
01-27-2017, 01:14 PM
I adopted this approach of filing pictures by date some years ago.

I really like this approach because I don't have to think about what category a picture goes in when I upload them. And I tend to remember events by the year and time of year that they occurred in so I'm able to easily locate a picture from a collection of 1000s.

elf
01-27-2017, 02:07 PM
If you're using a rational operating system and it allows you to look at a folder of anything with fields to sort by title, date, size etc. presumably if you've created the folders in chronological order, no matter what you've called them, you should be able to click in the date field above the date column and they would be presented by date created i.e. in chronological order.

If your operating system doesn't come with some kind of image browsing application, you need a different operating system. But if it does, you should be able to sort the images by date from the data embedded by the camera or phone in the header on each image.

CWSmith
01-27-2017, 02:13 PM
For some reason that simple solution just plumb evaded me.


We all do it, Chad.

I order computer files often and I don't want to admit how long it took me to realize I should reverse the date ordering. There are times I wonder how I get dressed in the morning.

cs
01-27-2017, 03:23 PM
If you're using a rational operating system and it allows you to look at a folder of anything with fields to sort by title, date, size etc.

That is Date modified. If I wait a day or two or even a week or so to download the pictures or if the files are modified at any time, that throws off the chronological order.

I'm just going to go like recommended and do the reverse date thing. Now I just gotta remember what the month number is. Is Feb 2 or 9 I can never remember. :D

Chad

Canoez
01-27-2017, 03:29 PM
That is Date modified. If I wait a day or two or even a week or so to download the pictures or if the files are modified at any time, that throws off the chronological order.

I'm just going to go like recommended and do the reverse date thing. Now I just gotta remember what the month number is. Is Feb 2 or 9 I can never remember. :D

Chad

That's why I recommended the photo album software - it uses the EXIF data from a digital camera. So long as your camera's date is set correctly, it stays with the file. If you're working with the camera on a phone, that data also can include geotagging, so you not only know when, but where.

The Bigfella
01-27-2017, 04:52 PM
2017-01-27

That's the way I do it too. I use annual folders, with date sub-folders like yours

Canoeyawl
01-27-2017, 11:16 PM
One alternative is to use hyphenated dates, like 1-27-2017, which will order themselves.

Edited to add: CWSmith's suggestion is even better: 2017-1-27

Some programs don't like hyphens. I just use the numbers...

20170127
20170128
20170129
20170130
20170201
etc

Nicholas Carey
01-27-2017, 11:32 PM
I'm always taking pictures of jobs for work and saving them on the server at work. Always keep them in a folder that is titled by the date, 27 Jan 2017, so we can back later and have chronological job progress record.

Okay when browsing pictures I end up with a list of folders that are labeled by date but the order is either alpha/numeric or date modified order. I would like to see these in a true chronological order when I browse the folder so I can just start at the top and go down in true order without having to jump around.

To accomplish this I'm thinking of starting each folder name with the Julian date and then the traditional date. For example instead of a folder being named 27 Jan 2017 I would name it 7027 27 Jan 2017. That way when ordering it alpha/numeric it would be in a true chronological order when browsing.

Does this make sense? Any better suggestions?

Chad


Don't reinvent the wheel: ISO standards are your friend.

ISO 8601:2004 (Data elements and interchange formats -- Information interchange -- Representation of dates and times) (http://www.cl.cam.ac.uk/~mgk25/iso-time.html) provides what you need.

ISO 8601 represents the date/time: November 7th, 2017 at 11:45:47.789 pm as

2017-11-07T23:45:47

This form

- human-readable
- is unambiguous
- collates (sorts properly)
- compares properly

Just lop off any bits from the right that you don't need. All these are valid representations of the same moment in time differing only in precision:

- 2017
- 2017-11
- 2017-11-07
- 2017-11-07T23
- 2017-11-07T23:45
- 2017-11-07T23:45:47

It supports week-of-the year as well: 2017-W03 is the 3rd ISO week of calendar year 2017.

ISO weeks start on Monday and end on Sunday...and the 1st week of the year is the 1st week containing a Thursday (aka the 1st week containing January 4th). One might note that this means that the 1st week of a calendar year might start in the previous calendar year.

And if you want to pull a day into the week representation, it's as easy as 2017-W02-3 (the 3rd day - Wednesday - of the 2nd week of calendar year 2017). Append a time ('THH:MM:SS' as above) if you want a time.

Garret
01-27-2017, 11:38 PM
As suggested: YYYYMMDD. I'm with Canoeyawl & simply make it 20170127.

If you do use a separator, you have to be 100% consistent: 2017_01_27 will not follow 2017-01-26, it'd be the other way round as hyphen sorts before underscore in Windoze.

CWSmith
01-27-2017, 11:41 PM
Some programs don't like hyphens. I just use the numbers...

20170127
20170128
20170129
20170130
20170201
etc

I get computer files like that from one particular source. Once you have a page or more of them, it's slow to read through them to find what you want. Computers love them. Humans not so much. However, you play the hand you're dealt.