AnsweredAssumed Answered

Relative Date to something other than Current Date

Question asked by BrianStadnik2741 on Jul 6, 2017

Hi, it seems like it would be really great to be able to have an option to create a parameter of a relative date based on something other than the Current Date. 

 

 

For example, the "Last Successful Run Date".  I am trying to run against an API looking that accepts a begin and end time.  I would like to see all the records that changed since the last successful run date.  The problem is the atom is running on a server in UTC timezone.  The server that serves the published API (a vendor that we don't have control over is in the Eastern US time zone.  So, I need to do the "Last Successful Run Date" - 4 Hour(s). 

 

From what I can tell now, the only solution is some custom javascript/groovy code, which I have to put in a map or data processing step prior to the properties shape.  (I know there is another request for adding custom scripting in the Set Properties shape itself.

 

Also, if there is a better way to accomplish this, that would be great to know as well.

 

Thanks!

Brian.

Outcomes