Date Parameter in a Generic Inquiry

Looks like you’re just missing brackets on your conditions.  Everything else looks perfect.  ;) 

Here’s one I have for Invoices by DocDate

If that doesn’t work, attach your GI here and I’ll take a look.

@jamesh,

Good morning,

That didn’t work.  I noticed on your screenshot that there is a small calendar icon by your date, but on mine it has a drop-down arrow.  I have attached my GI for reference.  This seems so simple, but it is not running right.

Thank you for your help!  

Trisha

Hello @tveld ,

Dates may need to be converted, in order to compare them in a GI.  See this previous post answered by Laura Jaffe:

Laura

@jamesh  & @Laura02 ,

I added the value =Today() to my conditions.  It will pull in the whole report, not just the date specified.  I did read the post that @Laura02  mentioned as well.

I have tried different ways with the brackets, with no success.

I am currently just using the one table. So, I know there are no joines issues.

Any other ideas?  Also, not sure how to view attached GIs from here.  It opens up just as text. (new to this part of it).

Thank you,
Trisha

@frederickodendaal77 ,

Thank you!  Adding that header table did help get that date issue corrected.  My report is now working correctly!

Thank you to everyone who offered tips! @Laura02 , @jamesh 

Trisha

Thanks for sharing the GI - I’ve made some adjustments.  Using a join and adding the CountDate field instead solved the issue. 

Attached the GI with the changes.

@tveld If you need to use the CreatedDateTime field then you can do the following in the generic inquiry.

Remove all the conditions and then do the filter directly on the relations:

=LEFT([INPIDetail.CreatedDateTime],11)

@frederickodendaal77 ,

I didn’t realize that I could do that within the relations.  Now they want it as a date range (wasn’t mentioned before).  

Thank you for all your pointers!

@tveld - Here’s an updated GI with the date range ;)

@jamesh ,

Might be a silly question but, how do I view your GI?  When I open it, it shows me the text view.  I not familiar with doing that step.

Thank you,

Trisha

Ahhh, you go to your Generic Inquiries screen, and where you exported it, you select Import instead.  It will pull it in for you. I kept the naming convention you had and GI number for your site map as well.  :) 

@jamesh ,

Wow!  Now I do feel silly!  I have used that for other things but didn’t think to use it for that.  Goodness!  Glad it’s Friday!

Thank you!

No worries. It’s practically the weekend! Haha 😂 That’s why I try to include screenshots. None of us know everything!!! Hopefully that finally solves your issues. 
Take Care,

James

@jamesh .

Yes!  At this time I feel I’m where I need to be with it!

Thank you so much for help!

Trisha