Everything Properties - EXIF: Date Taken <-> Windows Property System - Aufnahmedatum (German)

[tuska]

Hi,

Properties: Date Taken (Everything Properties - EXIF: Date Taken)
[x] Include files
Include only files: D:\Bilder\**.jpg
[x] Fast Sort

Properties: Aufnahmedatum (Windows Property System - Aufnahmedatum (German))
[x] Include files
Include only files: D:\Bilder\**.jpg
[x] Fast Sort

Right click on column header -> Add Columns... "Date Taken", "Aufnahmedatum".

Everything Language: English (UK)

• Right click on "Date Taken"
• Click on "Search for Date Taken" -> date-taken: is displayed in the search box of 'Everything'
• Enter "Date taken", e.g. 2.4.2021 -> search results with "Date taken" 2.4.2021 from the indexed folder "D:\Bilder"
  inclusive subfolders are displayed -> date-taken:2.4.2021 is displayed in the search box of 'Everything'.
   
• Right click on "Aufnahmedatum"
• Click on "Search for Aufnahmedatum" -> system.photo.datetaken: is displayed in the search box of 'Everything'
• Enter "Aufnahmedatum", e.g. 2.4.2021 -> search result: 0 objects

- Everything Language: Deutsch (Systemstandard) -> did not help.
- Changing the system language from German to English did not help either,
  except that the column heading was also changed from "Aufnahmedatum" to "Date taken".

Please check.
Thank you!

[void]

Thanks for bringing this issue to my attention Tuska,

I will work on a fix.
Everything is missing the propertysystem: prefix.

For now, please try the following search:

propertysystem:system.photo.datetaken:<my date search>

where <my date search> is date, for example: 15/05/2021

[tuska]

Thank you for the prompt response!

Code: Select all

propertysystem:system.photo.datetaken:02/04/2021

brings me no result, but for me there is no hurry....

[void]

Thanks for checking.

Windows is inserting LTR markers in the filetime text.

I will work on a fix.

For now:
wildcards:propertysystem:system.photo.datetaken:*02*/*04*/*2021*

There's an invisible LTR marker before 02, 04 and 2021.

[tuska]

For now:
wildcards:propertysystem:system.photo.datetaken:*02*/*04*/*2021*

Thanks, but unfortunately, that doesn't work either.

[void]

Does:
wildcards:propertysystem:system.photo.datetaken:*2021*
find any results?

Please make sure the search matches the same display format, eg:
DD/MM/YYYY

The syntax is different to the normal Everything syntax.
propertysystem: will always treat the value as text (not a date)

[tuska]

Thanks!

These queries work:

Code: Select all

wildcards:propertysystem:system.photo.datetaken:*2021*
wildcards:propertysystem:system.photo.datetaken:*02*.*04*.*2021*

[void]

Everything 1.5.0.1260a will now ignore control characters (LTR and RTL markers) when match diacritics is disabled.

This change requires a rebuild of your index.

Searching for propertysystem:system.photo.datetaken:02.04.2021 should now work as expected.

[tuska]

Searching for propertysystem:system.photo.datetaken:02.04.2021 should now work as expected.

Yes, it does and just like property-system:system.photo.datetaken:02.04.2021

Thank you for the bugfix!
Tested with Everything 1.5.0.1260a (x64) | Windows 10 Pro (x64) Version 20H2 (OS build 19042.985).
---------------------------------------------------------------------------------------------------------------------------

I have noticed differences in the query, namely from
1    Date Taken      (= "Aufnamedatum" in German)
2    Aufnahmedatum   (= "Date Taken" in English)

1    Date Taken (date-taken:)
1.1 Entering the day, eg 27, does not yet bring photos with the date of the 27th -> please see: point 2.1
      The date must be entered completely in order to receive a search result.
1.2 Entry of "Date Taken" is also possible, for example, in the following formats: 27.1.2021, 27/1/2021 (German)
      MM = month must always be entered with 2 digits .. 9.02.2021 works!
1.3 It is possible to record a period, e.g. date-taken:27.1.2021..17.2.2021
 
2    Aufnahmedatum (property-system:system.photo.datetaken:)
2.1 Entering the day, e.g. 27, brings photos with a date of 27.
2.2 When entering the "Aufahmedatum", the following format is mandatory: TT.MM.YYYY (German)
2.3 It is not possible to record a period, e.g. property-system:system.photo.datetaken:27.01.2021..17.02.2021

Suggestion:
If you could make an adjustment to the "best of both worlds", then I would be pleased.
1.2 -> 2.2
1.3 -> 2.3
2.1 -> 1.1

Thank you for your efforts!

[void]

date-taken: Uses the Everything date syntax.
property-system:system.photo.datetaken: Uses a text search.

Date syntax expects a year, year-month, or year-month-day.

Use the tostring: search modifier to search the date-taken property as text.
For example: tostring:date-taken:27.
(Note the text search will need to match the displayed text)

Everything knows Date Taken is a date property.
Everything doesn't know property-system:system.photo.datetaken: is a date property.

1.1 Entering the day, eg 27, does not yet bring photos with the date of the 27th -> please see: point 2.1
The date must be entered completely in order to receive a search result.

Use tostring:date-taken:27. or tostring:date-taken:27/ depending on how the date is displayed.

1.2 Entry of "Date Taken" is also possible, for example, in the following formats: 27.1.2021, 27/1/2021 (German)
MM = month must always be entered with 2 digits .. 9.02.2021 works!

When Everything knows the property is a date, it will accept a variety of date syntaxes., such as d.mm.yyyy or d/mm/yyyy or yyyy-mm-dd

1.3 It is possible to record a period, e.g. date-taken:27.1.2021..17.2.2021

When Everything knows the property is a date, you can specify a range with .. and use operators such as > or <=

2.1 Entering the day, e.g. 27, brings photos with a date of 27.

2.2 When entering the "Aufahmedatum", the following format is mandatory: TT.MM.YYYY (German)

2.3 It is not possible to record a period, e.g. property-system:system.photo.datetaken:27.01.2021..17.02.2021

Everything will match this property as text.
Everything doesn't know it is a date.
The search must match the display format.

If you could make an adjustment to the "best of both worlds", then I would be pleased.
1.2 -> 2.2
1.3 -> 2.3
2.1 -> 1.1

I will consider a todate: search modifier to do this.
or, a property-system-date: search function.
I can't guarantee it will match correctly as the property system can store values any way they like and render the text any way they like.

[tuska]

Thank you for this very detailed and informative information!

Use tostring:date-taken:27. or tostring:date-taken:27/ depending on how the date is displayed.

In my case, tostring:date-taken:27 is required (German).

I will consider a todate: search modifier to do this.
or, a property-system-date: search function.
I can't guarantee it will match correctly as the property system can store values any way they like and render the text any way they like.

If it is not certain for me that I will get a correct search result, then I prefer to do without such a function.
Therefore, my choice clearly falls on the parameter date-taken: because this meets all of my requirements.

Thanks again!

[void]

Everything 1.5.0.1262a adds a property-system-date: search function.

property-system-date: will 'attempt' to convert the system property data to a filetime for comparison.
I say 'attempt' here because there is no way to know if the property data represents a filetime.

Usage:
property-system-date:<property-system-canonical-name>:<Everything date syntax>

You can find the <property-system-canonical-name> list under Result List Header -> Right click -> Add Columns -> Windows Property System.

Examples:
property-system-date:system.photo.datetaken:2008..2015
property-system-date:system.photo.datetaken:2021-05-28
property-system-date:system.photo.datetaken:>2020
property-system-date:system.photo.datetaken:today

[tuska]

I have now added this field.

Right-clicking on "Aufnahmedatum" -> "Search for Aufnahmedatum" brings up the following in Everything's search box:

Code: Select all

property-system:system.photo.datetaken:

However, the new parameter should be present:

Code: Select all

property-system-date:system.photo.datetaken:

Could you please check? ... property-system-date:
Thanks!

A random check gave me a very good result.

Windows Property System – Search: system.photo.datetaken

Code: Select all

----------------------------------------------------------------------
Name		Type			Canonical Name:
Aufnahmedatum	Property System  	System.Photo.DateTaken
----------------------------------------------------------------------
Result		Shown			Intern
- Everything	17.‎09.‎2019 ‏‎11:50
- Excel		17.‎09.‎2019 ‏‎11:50	'‎17.‎09.‎2019 ‏‎11:50
======================================================================

For comparison...

Everything Properties – Search: date taken

Code: Select all

----------------------------------------------------------------------
Name		Type			Canonical Name:
Date Taken	Metadata	  	Date Taken
----------------------------------------------------------------------
Result		Shown			Intern
- Everything	17.‎09.‎2019 ‏‎11:50
- Excel		17.09.2019 11:50	17.09.2019  11:50:58
======================================================================

Thank you for your efforts!

[void]

Thanks for testing tuska,

Right-clicking on "Aufnahmedatum" -> "Search for Aufnahmedatum" brings up the following in Everything's search box:
property-system:system.photo.datetaken:

This is expected.
Everything doesn't know this property is a 'date' property.


While the property does have a FILETIME storage, it might be possible to guess it is a date property.
However, this cannot be guaranteed to be correct.

I will consider defaulting to property-system-date: for properties with FILETIME storage.