If Function for a time frame

[Dean Redding]

Hi,

I am trying to write a if function that can change the end date if the finish time is between 12:00am and 6:00am.

This is what I would like to happen...

If (Main Screen: Finish Time = "12:00 am ... 6:00am"; Main Screen: End Date+1; Main Screen: End Date)

Can anyone help me out on how I can do this range?

Many Thanks,

Dean

[comment]

You could do it this way:

If ( Main Screen: Finish Time ≤ Time ( 6 ; 0 ; 0 ) ; Main Screen: End Date + 1 ; Main Screen: End Date )

 





or more concisely:

Main Screen: End Date + ( Main Screen: Finish Time ≤ 21600 )

Edited March 16, 2008 by Guest