For one of the reports I need to produce through Logi, I need to create a parameter/filter and pre-populate it with items from a query.   Has anyone done that before?  And if so how did you do it?

Thanks,

Kris 

A report that I need to create - I need to write a class method that will execute a few queries and save the data to a class and then return the data in a result set that can be used in the Logi report as a Stored procedure.

I can create the class method that is a Stored procedure and do the queries and manipulate the data, however I am having an issue at the end of the method to return the fields back as a result set.

• I take a time stamp and convert it to a PosixTime
• Then for an Timezone offset (for example America/New_York would be -05:00) convert it to seconds  -18000
• I add the -18000 to the PosixTime
• I convert the PosixTime to time stamp - shouldn't the time stamp show a lot more of a difference?  
• 
• I am guessing that adding -18000 is not really a difference of 5 hours?   What am I missing?

Thanks,

Kris

Working on a project where we have a web browser that we have to determine a pickup date/time for a pharmacy in a different time zones.

We store the different time zones with their Daylight and Standard offsets.

We have a object script method that figures out the the pickup date/time for a particular pharmacy in their local time zone but the data is being returned in the $H format.   

We now need to return it in a UTC format.  I see different methods but don't see a method that will change the $H into a UTC for a different timezone otherwise than the local timezone.