I have data that is time-stamped with the date and time as a number. I can convert that to date and time without any problem. It's also in GMT time and I can convert the date and time to local time. What I'm having trouble with is I want to ad a slider object so the user can select a time range. I can do this but my time range is represented in GMT. I'm in the Eastern time zone (GMT - 5) so my slider goes from 7:00 PM to 6:59 AM and I would like it to go from 12:00 AM - 11:59 PM local time, of course. I've tried sorting my slider different ways but I cannot seem to get it to work. This is my slider field
=Time(ConvertToLocalTime(Frac([Date Time(RAW)])))
where [Date Time (RAW)] is the numeric value of the date and time of the data.
I've tried sorting on this same expression without any luck. Any ideas on how to do this?
Thanks.
