Convert DateTime from GMT to EST in DataFlow in DS
I have a problem I am struggling with in a data flow of one of our ETL's. I have a column that is DateTime but it is in GMT time. I need to convert this to Eastern Standard Time zone so when it populates the table its already been converted to our time zone. I having difficultly finding a way to convert this. Please help!