Publié Thu, 03 Nov 2022 04:25:26 GMT par Jason Scott

I need a list of documents from the current month. I've tried this https://support.docuware.com/en-us/knowledgebase/article/KBA-36650 I keep on getting a Wrong Condition error. What is the correct format meant to be, or is there another way to do this?

Publié Mon, 07 Nov 2022 10:40:52 GMT par Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
Hi Jason, 

the KB article does not really mention it, but it is only necessary for text fields. 
If you have a date field, you can just use the filter option "within the last" and select 1 month, see Screenshot.



Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant
Publié Mon, 07 Nov 2022 22:51:56 GMT par Jason Scott
Hi Simon, 

The KBA seems very specifically about DATE fields, so I'm confused by your response regarding the TEXT fields.

Also, filtering by "within the last 1 month" returns documents from the past 30 days, and not the CURRENT MONTH as per my quesition. 
Publié Thu, 01 Dec 2022 15:43:54 GMT par Gerardo Lisanti Team Leader Product Management
Hi Jason,

try to use the "is (where clause)" condition with "THISMONTH".

Viele Grüße / With best regards,
--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

 
Publié Thu, 01 Dec 2022 22:50:32 GMT par Jason Scott
Hi Gerardo, 

UPDATE: This actually does work on 7.7. Thanks for this 

Below is what I get on 7.6 which is where i was testing this. 

Wrong condition! Field : DWSTOREDATETIME Value : THISMONTH

 

You must be signed in to post in this forum.