I've got a range of data dating from 2013 Jan 12AM to 2013 Aug 12PM
I need to select the data range between 12 hours before current time and 6 hours after current time.
However, I am able to view past data within the 18 hours time frame as well.
What is the best way to do this?
Creating a calculation similar to the following should get you the available date times in this range:
if [DateTime]>=DATEADD('hour', -12, now()) and [DateTime]<=now() or [DateTime]<=dateadd('hour', 6, now()) then [DateTime] end
Hope this helps!