swaink
Active Member
- Joined
- Feb 15, 2002
- Messages
- 432
Hi
I have data that includes two Date cols and Two time cols these being date/time of arrival and Date/Time of Departure.
The data has been imported and occasionally the depart time is showing that the departure time is before the arrival time which cant be.
I have been trying to write a macro that checks each entry to see if the departure time is less than the arrival and if so change the field colour.
My problem is this, if an arrival time is say 23:30 hrs and the departure is 01:00 hrs the following morning it gets coloured when it should'nt be.
Can anyone advise how I may get around this problem.
King regards
Kevin
This message was edited by swaink on 2002-03-29 02:10
I have data that includes two Date cols and Two time cols these being date/time of arrival and Date/Time of Departure.
The data has been imported and occasionally the depart time is showing that the departure time is before the arrival time which cant be.
I have been trying to write a macro that checks each entry to see if the departure time is less than the arrival and if so change the field colour.
My problem is this, if an arrival time is say 23:30 hrs and the departure is 01:00 hrs the following morning it gets coloured when it should'nt be.
Can anyone advise how I may get around this problem.
King regards
Kevin
This message was edited by swaink on 2002-03-29 02:10