Time Range Problem

[gscheepers]

Hi,

I have table with two time fields, a start time and an end time. If a meetings start time is before 17:30 or the end time is on or before 17:30 then I want to set the start time to 17:30 else the start time should stay as is.

I've tried the formula underneath, but it's not giving me the exact result i'm looking for:

If {@TimeFromNum} >= time(17,30,00) and {@TimeToNum} > time(17,30,00)
then time(17,30,00) else
{@TimeFromNum}

Your help would be appreciated!

Thanks, Gerhard Scheepers
BA - LETEC

 

[kenhamady]

In your description you used the word OR, but your formula uses AND. That may be part of the problem. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com