What would be the expression formula to display a value on the report for the following SQL expression. Event .[EventStart1] >='19:00' and Event.[EventStart1] <= '23:59' (This works in SQL. It is just a TIME field in SQL, not DateTime) =IIF((Fields!EventStart1.Value >= "19:00") and (Fields!EventStart1.Value <= "23:59PM"), Fields!CombinedTime.Value,"") I cannot get this to work.

Remove PM in the second expression. Will it work?For every expert, there is an equal and opposite expert. - Becker's Law My blog

Sorry the PM is already removed but does not work =IIF((Fields!EventStart1.Value >= "19:00") and (Fields!EventStart1.Value <= "23:59"), Fields!CombinedTime.Value,"") I cannot get this to work.

Any takers

Please try =IIF((Fields!EventStart1.Value >= #19:00#) and (Fields!EventStart1.Value <= #23:59#), Fields!CombinedTime.Value,"")Remember to mark as an answer if this post has helped you.