Append time in criteria?

[natashiakk]

I am new to xml. We have a application where the report generation is in xml. One of the report printed all the job run on current day. However, our report requirement is to list the job run the day before after 8pm.

I am trying to modify the report, but only manage to get it to list all job run the day before, but can not append the 8pm criteria.

Here is the orginal settings:
asdate(job_record.jobstarttime) > convert(today, char, 11, 'yyyy-mm-dd')

I change it to the following:
asdate(job_record.jobstarttime) > convert(today-1, char, 11, 'yyyy-mm-dd')

How to append the time 20:00:00 on top of what I have modified.

Thanks for any advice in advance.

regards,
kk