Spotlight Raw Query for creation date and time

Discussion in 'Mac OS X System & Mac Software' started by Sisko, Apr 14, 2006.

  1. Sisko

    uix_expand uix_collapse

    Apr 14, 2006
    Likes Received:

    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

Share This Page