alder2009 Posted July 4, 2012 Share Posted July 4, 2012 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! Link to comment Share on other sites More sharing options...
eos Posted July 4, 2012 Share Posted July 4, 2012 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? Link to comment Share on other sites More sharing options...
alder2009 Posted July 4, 2012 Author Share Posted July 4, 2012 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 ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4311 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now