Hello Everyone.

I generate files in a new directory daily. Sometimes I generate multiple files for the day, each file is named exactly the same, each file goes in its respective folder, folders are named according to the create timestamp. So for a day I sometimes end up with more then one file of the same name in their respective folders.
for example:
/etc/20120104104002/myfile_01_04_2012.txt
/etc/20120105160003/myfile_01_04_2012.txt

I need to find the latest myfile_01_04_2012.txt. The one in 20120105160003 folder. I've tried
find /etc/ -iname myfile_01_04_2012.txt -type f | sort -n | tail -1

I sometimes get the last file generated (which is what I want) and sometimes it is the first file generated.(not what I want)

What am I doing wrong?

List the directories. They were created at the same time.

ls -1rd 2012*/ | head -1

If the sort order of the directories always sorts correctly, you can sort the directories with reverse sort so the most recent is first
ls -dr | head -1

/etc/ isn't the right directory for storing data. These look like log files. The directory to use for log files us /var/log. /etc is for static configurations.