Date and Time function

[alder2009]

Hi There,

I am having a bit of a problem. I know there is a simple solution but I can't work it out.

I have a date field that user enters, This field defines what date an order is ready to be picked up.

I have a time field that the user enters. This field defines what time an order is ready to be picked up.

I have a field called "pick up date". This is a calculation field that returns a pick up date. I need this to calculate a pick up date based on the previous two fields. For example:

If dayofweek (day) = Thursday and time (hh;mm;ss) > 16:00:00 then return "pick up date" as the following Tuesday.

I can't quite get the calculation to work. Please help, thanks!

[eos]

If dayofweek (day) = Thursday and time (hh;mm;ss) > 16:00:00 then return "pick up date" as the following Tuesday.

What is the logic behind this example calculation?

[alder2009]

Sorry guys, just worked it out. Incredibly simple

Case (

DayOfWeek ( Target_Cut End ) = 5 and Target_Cut End Time > Time ( 16;0;0 ) ; "Pick up Tuesday" ; 0 )