Validate Date / Time
I have a table that has four date & four time fields, corresponding with the stages of a job. Let's call them Stage 1, Stage 2, Stage 3 & Stage 4.
I need to ensure that the stage Stage 4 date & time >= Stage 3 date & time, stage 3 date & time >= stage 2 date & time & so on. I can validate by calculation that one date is >= to another but I can't work out how to do it in conjunction with a time. Can anyone point me in the right direction?