Syntax for filtering Date&Time custom field?

DEVONthink
1

:waving_hand: Greetings Wonderful DEVONians,

I am evaluating custom fields in the trial version of DEVONthink 4.

What is the proper syntax to filter documents on a Date & Time custom field called md_primary_timestamp ?

I have three test documents each confirmed in the UI to have the custom field md_primary_timestamp , taking values in [‘2014-01-16 09:56:35’, ‘2009-07-15 15:34:32’, ‘2008-02-16 12:19:28’]

Queries I’ve tried:

  • md_primary_timestamp>2008-02-16
  • md_primary_timestamp:>2008-02-16
  • md_primary_timestamp>=2008-02-16
  • md_primary_timestamp:>=2008-02-16
  • _Primary_Timestamp>2008-02-16
  • _Primary_Timestamp:>2008-02-16
  • _Primary_Timestamp>=2008-02-16
  • _Primary_Timestamp:>=2008-02-16

Thanks :folded_hands:

2

Did you name your attribute this?

3

Yes, it was assigned the name md_primary_timestamp via script. However, in the UI it displays it as _Primary_Timestamp

4

See my response in your support ticket.