Time Comparison in IF condition

[#1]

Hi Experts,

How do i compare a time in If condition i.e.

I have a DocCreateTime field (carrying just time with format: 11:05:30AM ) coming from database. I just want records, having time value lesser than 10:00:00AM.

How do i do that ?

Help Required please!

[dineshraj]

Hi Shazad,

I think this may help you

Let vTime='10:00:00AM'

And in Load script with where condition

where DocCreateTime <'$(vTime)'

Thanks