[quote=“MMaynardUSG”]in scripting I use the following to set date strings to valid date formats
[code]
from java.text import SimpleDateFormat
inputFormat=SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”) # Must match the format of the input string
outputFormat=SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”) # The format you want to convert to
dateIn=event.source.selectedStringValue
processedDateIn=SimpleDateFormat.parse(inputFormat,dateIn) # Convert Input String to Java Date
event.source.parent.getComponent(‘Power Table’).SDate=processedDateIn
event.source.parent.getComponent(‘Power Table’).EDate=system.date.addMinutes(processedDateIn,7)
[/code][/quote]
Thanks for the quick response. In this case I don’t use any scripting. just use my expression tag refrences in my SQL query. as I mentioned in my latest reply the problem seems to have been fixed with the couple of tweaks I made so we’ll see how that goes.