So i have raw file that has one date field, My crystal takes that date and addes two time fields to if from that file. i then have two fields the derive from the same date field, however the time in the fields is what is the difference (i.e. DOS = 3/14/08 23:23pm & Triage = 3/14/08 00:10am)

 

now triage should be read as 3/15/08 00:10am as it is the next day. I am trying to compare the hour and add to the date in my code below. Can any help and let me know what i may be doing wrong.

 

 

If Time(hour({@Arrival Date})) > Time(hour({@Triage time}))  then

    date(day({@Triage time}), day({@Triage time}), 1)+1

else

    {@Triage time}

 

date(day({@Triage time}), day({@Triage time}), 1)+1

 

and replace the whole line with:

 

{@Triage time} + 1

 

I tried that and now no dates show up in the field.

 

Thanks for your help by the way =)