I need to create a report of all the records between 7am to 5pm CST/CDT everyday. How can I achieve this?
The solution I tried -
- Created a formula field which extracts Hours from created date (Returns hours in GMT)
- Created a formula that checks the GMT in CST Time range.
How can I make this formula dynamic to take Daylight savings in consideration? Is there another/better approach? Please advise. Thanks.