Publié Mon, 03 Jun 2019 23:46:54 GMT par Michael Weingand Sales Engineer
Does anyone know how to create a dialog list of documents stored today. It's a simple list that I am looking for that just gets a document type called "Meal Waiver" for that day.  The client now has a form that I built for employees to fill out.  They just want to have a quick list for the forms that are filled out that day without having to build the search each time they want it.
Publié Tue, 04 Jun 2019 04:13:33 GMT par Phil Robson Senior Director Support - Americas
Create a new List dialog. Using the query designer select
Document Type "Is Equal" Meal Waiver
Add an AND clause
Select System field Store Date "Is Where" CURRENTDATE()

Phil Robson
Senior Director Client Services, Americas
Publié Tue, 04 Jun 2019 21:09:26 GMT par Michael Weingand Sales Engineer
HI Phil,
This is what I have done and it does not work.  See screen shot.  When I exclude the Store Date, I do get a results list with all docs, as I would expect but when I add the Store Date "Is Where" CURRENTDATE() I get nothing.  Any advice? 
Publié Wed, 12 Jun 2019 21:24:44 GMT par Matthew Trembly Software Support Manager
Phil's config will work for 7.1, but for anything 7.0 and previous, you'll need:

Store Date "Is (where clause)" >CURRENTDATE()

Because I believe DW system Store Date used to evaluate current date as datetime, so current date was always newer than store date even if was the same day.

It changes for the better in 7.1!
 

You must be signed in to post in this forum.