Distinct hours in list box

[gauravgg]

hi

when i removed hours form timestamp field

when i put hours in list box they are repeating in want only the distinct hours in the listbox

can anyone help me?

thanx in advance

[swuehl]

Use

LOAD

      Hour(TimestampField) as HourField,

     ...

instead of (assumed) formatting using Date() or Time() function, like Time(TimeStampField, 'hh')