load(
  local!count:17,
  local!a: split(ri!date,"T"),
  local!date : local!a[1],
  local!time: local!a[2],
  local!b: split(local!date,"-"),
  local!year: local!b[1],
  local!month: local!b[2],
  local!day: local!b[3],
  local!c: split(local!time,":"),
  local!hour: local!c[1],
  local!minute: local!c[2],
  local!second: left(local!c[3],2),
  local!x: gmt(todatetime(datetime(local!year, local!month, local!day, local!hour, local!minute, local!second))),
  local!counter: if(
    and(local!day>=10,local!month>=10),local!count+2,
  if(or(local!day>=10,local!month>=10),local!count+1,local!count)
  ),
  local!datasubset: a!queryEntity(
    entity: cons!SOA_ISO_COUNTRY_LIST,
    query: a!query(
      selection: a!querySelection(
        columns: 
        {
          a!queryColumn(
          field: "isoCountryTimeZone"
        ),
        a!queryColumn(
          field: "dayLightTimeDiff"
        ),
        a!queryColumn(
          field: "observeDST"
        )
        }
      ),
      filter: a!queryFilter(
        field: "isoCountryCode",
        operator: "in",
        value: ri!countryCode
      ),
      pagingInfo: a!pagingInfo(1,-1)
    )
  ).data,
  if(
    and(local!datasubset.observeDST = "1",isindaylightsavingtime(local!x,local!datasubset.isoCountryTimeZone)),
  left(tostring(local!x+(todecimal(ri!time)/24)+(todecimal(local!datasubset.dayLightTimeDiff)/24)),local!counter),
  left(tostring(local!x+(todecimal(ri!time)/24)),local!counter)
  /*substitute(tostring(local!x+timezone)," GMT+00:00","")*/
  ) 
)