>I have this two variables:
>
>ltEnterDatetimeEmployee = 29/09/2006 08:45:00 (data extracted from a datetime field)
>
>lcOfficalHourToEnter= "08:30:00" (data extracted from a char field)
>
>I need to determine if an employee is late, comparing both expression..
>
>
>Carlos Burgos

ldtOfficalHourToEnter = DATETIME(YEAR(ltEnterDatetimeEmployee),;
                                 MONTH(ltEnterDatetimeEmployee),;
                                 DAY(ltEnterDatetimeEmployee),;
                                 VAL(LEFT(lcOfficalHourToEnter,2)),;
                                 VAL(SUBSTR(lcOfficalHourToEnter,4,2)),;
                                 VAL(RIGHT(lcOfficalHourToEnter,2)))