I am trying to configure my start and end dates on a report that i am generating that is designed to cover a full month of data. Is there a way to set the start and end date parameters to recognize months? I am pulling data out of Ignition Historian if that matters.

Your question is a bit underspecified, but perhaps you're looking for something like this? [image] Ignition Report: Getting 1st day and last day of the month Ignition First day of month: getDate( getYear({date}), getMonth({date}), 1 ) Last day of month: addDays( ge…

I am working in the Reporting Module and am trying to use the Start Date and End Date parameters for a dynamic query to cover all of the records for the current month. I will issue the report at 11:00 pm on the last day of the month. This report has to be issued on the last day of every month. I …

Wouldt this work for you? [image] Are you using the Tag historian source binding for the history? or via scripting? both should take a start and end date.

no i will not. I am using MySql. It appears that this will work up to ~10 days of history but after that there is something that is changed in the way the date is coded. I keep getting the following error "ERROR: The value '129:49:19' is an invalid TIME value. JDBC Time objects represent a wall…

[image] Neil_Carty: Month(column) = Month(currentdate()) For MySQL, its current_date() or curdate() not currentdate(). Maybe it's just a typo, but I thought I'd mention it. You could also use now()

Can you show us how you're querying the historian database? I'm unsure where/how you're getting the date objects casted to duration.

Issue month end report

Ignition

paul-griffith April 26, 2023, 6:59pm 2

Your question is a bit underspecified, but perhaps you're looking for something like this?