You are viewing limited content. For full access, please sign in.

Question

advanced search syntax for day of the month

Search and Retrieval

Updated April 6, 2017

asked on April 5, 2017

How would I search a date field for any year, any month, 5th day?

Leaving month and year blank doesn't work, neither do wildcards.

0 0

Replies

replied on April 5, 2017

Can you tell us more about why you want to run this search? You're correct that date search doesn't support wildcards, but we might be able to come up with a workaround.

0 0

replied on April 6, 2017

A customer stores credit card statements. The field "statement date" is always the 5th of the month. They wanted to find statements where the date was NOT the 5th of the month in order to correct them.

In this case we use date as part of the document name, so I wrote a workflow that searched the name for the pattern *-05 -*. I moved all those documents from their Records archive back to their working area and they were happy.

{[Purchasing Cards]:[P-Card Type]="Statement"} - {LF:Name="*-05 -*", Type="D"}

1 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 5, 2017
Updated April 6, 2017
77 views