View Full Version : Spotlight Raw Query for creation date and time

April 14th, 2006, 04:24 AM

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.


Powerbook 17, PPC, OS X 10.4.6