I am trying to dynamically change the date selected when i activate the internal frame. The queries dont give me any errors, but the date isnt changing. I think its due to format errors, but i am not sure. here is my code
[quote]start_date = fpmi.gui.getParentWindow(event).getComponentForPath(‘Root Container.Start Date’).date
end_date = fpmi.gui.getParentWindow(event).getComponentForPath(‘Root Container.End Date’).date
start_date = fpmi.db.runScalarQuery(“select now() from hmi_data”)
end_date = fpmi.db.runScalarQuery(“select date_sub(now(),interval 1 day) from hmi_data”)
[/quote]