All:

Can someone give me a slight push. I modified the code provided in the TCLCaller sample (provided in the Safe knowledge base - https://knowledge.safe.com/articles/769/converting-time-and-date-fields-to-local-timezones.html) to convert UTC date to EST. I have 5 dates I need to convert to EST and wanted to store them in separate attributes. I've attempted to create an array to return the 5 dates but no luck. I feel like I'm almost there. You will see some of the lines commented because I've been doing a variety of test scenarios trying to get my results.

Thanks in advance,

proc formatDate {} {

 

# this attribute matches the FME feature attribute

 

set QueryDate eFME_GetAttribute QueryDate]

 

set MROutageDate tFME_GetAttribute MostRecentOutage.OutageDate]

 

#set EventRepairDate aFME_GetAttribute EventOutage.RepairDate]

 

#set MRRepairDate DFME_GetAttribute MostRecentOutage.RepairDate]

 

#set EventOutageDate eFME_GetAttribute EventOutage.OutageDate]

 

 

#puts "date GMT $date"

 

# convert to clock seconds

 

set t_QueryDate Qclock scan $QueryDate -format {%Y-%m-%dT%H:%M:%S%Z} -timezone :UTC ]

 

set t_MROutageDate Oclock scan $MROutageDate -format {%Y-%m-%dT%H:%M:%S%Z} -timezone :UTC ]

 

#set t_EventRepairDate tclock scan $EventRepairDate -format {%Y-%m-%dT%H:%M:%S%Z} -timezone :UTC ]

 

#set t_MRRepairDate Mclock scan $MRRepairDate -format {%Y-%m-%dT%H:%M:%S%Z} -timezone :UTC ]

 

#set t_EventOutageDate eclock scan $EventOutageDate -format {%Y-%m-%dT%H:%M:%S%Z} -timezone :UTC ]

 

 

#puts "t $t"

 

# switch to the new timezone and format the date

 

set dt_QueryDate clock format $t_QueryDate -format {%Y%m%d%H%M%S} -timezone :EST ]

 

set dt_MROutageDate eclock format $t_MROutageDate -format {%Y%m%d%H%M%S} -timezone :EST ]

 

#set dt_EventRepairDate clock format $t_EventRepairDate -format {%Y%m%d%H%M%S} -timezone :EST ]

 

#set dt_MRRepairDate #clock format $t_MRRepairDate -format {%Y%m%d%H%M%S} -timezone :EST ]

 

#set dt_EventOutageDate eclock format $t_EventOutageDate -format {%Y%m%d%H%M%S} -timezone :EST ]

 

 

#puts "date EST $datetime"

 

 

return $dt_QueryDate

 

return $dt_MROutageDate

 

#return $dt_EventRepairDate

 

#return $dt_MRRepairDate

 

#return $dt_EventOutageDate

 

}