Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are extracting time intervals from a timestamp field. We would like to use this as a filter but the values are repeating. We only need a list of intervals from 12:00 am to 11:30 pm, so the list should only be 24 values.
Load script currently: Time(DateTime) as DateTimeIntervals
replacing frac with num corrects the interval issue but it repeats again.