How to i convert a date time feild to be able to compare times that fall over midnight


  • the current format of my date and time feilds (work date, start time & end time) is :2013-07-09 20:00:00.0

    I need to return the time component as 24hr value (hh:mm)  for start end end time feilds. I THEN need to perform comparisons against the time value, e.g.

    end time  > = break start time etc

    the issue is that i cannot work out how to format the time so it recognises the calculation for each independant work date, i.e. calculation does not work when times fall over midnight 

    Wednesday, August 07, 2013 3:18 AM


All replies