We deal with timezone in our databases. if it is EPT between apr to oct , then it is EST date +1/24 or else it is same as est.
EPT EASTERN PREVAILING TIME
EST EASTERN STANDARD TIME
How can i incorporate this in reports , that when the user pulls the est / ept from drop down list, it automatically gives the data for the corresponding timezone.