Is it possible in a Generic Inquiry to generate a result that lists every calendar day between two dates?
For example, I have StartDate and EndDate, and I need the GI to show each date within that range, even if there are no records for those days in the underlying table.
Solved
How to display all days between two dates in a Generic Inquiry?
Best answer by lauraj46
Hi
You can use the DateInfo DAC. It contains a record for every date from 1/1/1970 to 6/6/2079.
Hope this helps!
Laura
+2
If you’re savvy with Excel, you could do an OData feed and pull data into an Excel sheet and aggregate it by date in a separate table.
Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
+8Hi
You can use the DateInfo DAC. It contains a record for every date from 1/1/1970 to 6/6/2079.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.