What is the exact format of the Date Column? Does it have a custom date format mask? Is it an actual date column or a string with a date format? Some screenshots may be helpful in getting a better understanding of your issue.
I can't upload screenshots because I work on computer that isn't connected to the net.
The column is date that in the rpd cast to time.
The first format i try with is custom HH:mm,
I try also don't override the default format or use suggest formats like [FMT:time] or [FMT:timeODBC] but it didn't solve the problem.
Just to update that finally I used the field as date type, I set the data format as HH:mm,
and the problem solved.
I think that the problem is with time field type.