Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Convert a char expression into a time expression
Message
From
29/09/2006 13:00:10
 
 
To
29/09/2006 12:19:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158168
Message ID:
01158206
Views:
35
>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
ltEnterDatetimeEmployee = CTOT("29/09/2006 08:45:00")

lcOfficalHourToEnter= "08:30:00"

? "LATE ",ltEnterDatetimeEmployee > CTOT(STUFF(TTOC(ltEnterDatetimeEmployee),12,8,lcOfficalHourToEnter))
Previous
Reply
Map
View

Click here to load this message in the networking platform