how to compare datetime in sql

See more:

SQL-Server

I have a view in which i have multiple columns i have to make a query in i want to match to colums of dates.
means attendence time in is greater then shift time then it will show employee data from views. how will i do it.
having problem in where clause

where convert(datetime, ShiftTimeIn) <= convert(datetime, CreatedOn);