Skip to Content
avatar image
Former Member

Formula to Convert AZ time to Pennsylvania Time

I have a database, that I do not manage. In the database are several date and time fields, which are in Arizona time (who does not use daylight savings). I am in Philadelphia, Pennsylvania. We have EST & EDT. I need to find a formula that will allow me to have the date and time display in Pennsylvania time, correctly, no matter when the report is run or for what time period it is for. We consistently run reports for data over months and years at a time so a basic "add a few hours" would not work :-(

I have been googling like crazy and I am not finding anything. Unfortunately my CR skills are self taught so what I have found has been a little foreign to me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers