Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you attach your sample file?