AnsweredAssumed Answered

Validate Date / Time

Question asked by Peter_2 on May 14, 2012
Latest reply on May 15, 2012 by Sorbsbuster


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?