AnsweredAssumed Answered

Search by day/week/trimester

Question asked by lilwey on Aug 9, 2018
Latest reply on Aug 13, 2018 by SteveMartino


I have the follow dashboard:

issue.png

 

Each table don't have exactly the same dates, some have dates of  a month ago while some have today's date. So, I research a lot, but always is the same message "no results match the search criteria"; my question is, how can I search by day, trimester, and week? Considering my relationhips.

 

Extra info: I'm using a ODBC connection, so the dates in each table appear like date and hour,  I don't know if that produces me the error. And every attempt (scripts, search tables relationated, find request) I deleted it, and in this moment I need help seriously.

 

Thanks for any help.

Outcomes