ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error comparing date win2003 Server (https://www.excelbanter.com/excel-programming/315165-error-comparing-date-win2003-server.html)

Fernando

Error comparing date win2003 Server
 
Hi,
I have the following line:
If regs_hrMax < lastHr Then

regs_hrMax is a Date variable
lastHr is a Date constant = "11:00 PM"

99% of the times this comparison will execute fine, ex:

If "6:00 PM" < "11:00 PM" Then -- TRUE
If "3:00 AM" < "11:00 PM" Then -- TRUE
If "10:00 PM" < "11:00 PM" Then -- TRUE

but when comparing:

If "11:00 PM" < "11:00 PM" Then -- FALSE

This only hanpends in Win 2003 Server, the same VBA proyect on Win XP or
2000 wont do this!, why is this happening?, I dont really know much about Win
Server, could it be a configurationm problem?

Thanks,
Fernando


All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com