Hi,
I've been trying to create a raw query in Spotlight to find files created between a date and time. (For when I want to work out what was installed with a new application)
Though the standard " created today" option does return the date created with time in the modification column I wanted to be able to filter within a smaller range of results.
So far I've had limited success using:
kMDItemFSCreationDate >= $time.iso(20061404T172342)
but it also returns files from other dates.
I was trying to end up with a query that might work like this ( Show me files created on 14 April, 2006 between 5pm and 5.30pm)
(kMDItemFSCreationDate >= $time.iso(20061404T170000)) && (kMDItemFSCreationDate < $time.iso(20061404T173000))
I also tried adapting Windstorm's 'Moru' search string
((((kMDItemFSCreationDate >= 166629600) && (kMDItemFSCreationDate < 166716000)))) but I haven't been able to work out how the date is in those numbers.
Many thanks for any help. I am not a techie and have been playing around with the above from reading about raw queries all over the place.
Sisko
Powerbook 17, PPC, OS X 10.4.6
I've been trying to create a raw query in Spotlight to find files created between a date and time. (For when I want to work out what was installed with a new application)
Though the standard " created today" option does return the date created with time in the modification column I wanted to be able to filter within a smaller range of results.
So far I've had limited success using:
kMDItemFSCreationDate >= $time.iso(20061404T172342)
but it also returns files from other dates.
I was trying to end up with a query that might work like this ( Show me files created on 14 April, 2006 between 5pm and 5.30pm)
(kMDItemFSCreationDate >= $time.iso(20061404T170000)) && (kMDItemFSCreationDate < $time.iso(20061404T173000))
I also tried adapting Windstorm's 'Moru' search string
((((kMDItemFSCreationDate >= 166629600) && (kMDItemFSCreationDate < 166716000)))) but I haven't been able to work out how the date is in those numbers.
Many thanks for any help. I am not a techie and have been playing around with the above from reading about raw queries all over the place.
Sisko
Powerbook 17, PPC, OS X 10.4.6