Publicado Mon, 03 Jun 2019 23:46:54 GMT por Michael Weingand
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.
Publicado Tue, 04 Jun 2019 04:13:33 GMT por Phil Robson
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
Publicado Tue, 04 Jun 2019 21:09:26 GMT por Michael Weingand
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? 
Publicado Wed, 12 Jun 2019 21:24:44 GMT por Matthew Trembly
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.