Anh_Tran Posted June 30, 2004 Share Posted June 30, 2004 Hi All, I have a problem on date calculation. Let's say on given date (2004-July-03)always on Saturday, I create 7 fields calculated depend on (2004-July-03)...as followed .. Sunday = 2004-June-27 Monday = 2004-June-28 Tuesday = 2004-June-29 wednesday = 2004-June-30 Thursday = 2004-July-01 Friday = 2004-July-02 Saturday = 2004-July-03 If I do a find from 2004-July-03 to 2004-August-03, it will caculate hours from Thursday to Saturday and If I do a find from 2004-June-01 to 2004-july-03, i will calculated hours from Sunday to Wednesday. I don't know if you understand well my point. I got stuck big time here since the design is something different to do this thing. Any help will really appreciated. Anh Tran Link to comment Share on other sites More sharing options...
-Queue- Posted June 30, 2004 Share Posted June 30, 2004 June 1st is a Tuesday and July 3rd a Saturday. How does that relate to 'Sunday to Wednesday'? Can you elaborate more on what exactly you're trying to do? Link to comment Share on other sites More sharing options...
Anh_Tran Posted June 30, 2004 Author Share Posted June 30, 2004 What I mean is that On given date (2004-july-03)... it will recognize automatically days before july (means june 27 to june 30) and after june is (july 01 to july 3). How does it recognize? Do I have to create 2 fields to calculate or just one field? Thanks Anh Tran Link to comment Share on other sites More sharing options...
RalphL Posted June 30, 2004 Share Posted June 30, 2004 Is this what you want? Field SaturdayDate of type date SundayDate calculated date field = SaturdayDate - 6 MondayDate calculated date field = SaturdayDate - 5 TuesdayDate calculated date field = SaturdayDate - 4 WednesdayDate calculated date field = SaturdayDate - 3 ThursdayDate calculated date field = SaturdayDate - 2 FridayDate calculated date field = SaturdayDate - 1 Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted June 30, 2004 Share Posted June 30, 2004 Huh ! What exactly is the goal and find purpose, Mr Argh Tranh ? (kidding !) Link to comment Share on other sites More sharing options...
Anh_Tran Posted July 1, 2004 Author Share Posted July 1, 2004 Thanks All, My problem is a little hard to explain for you guys, my experts, I will solve it later. Anyway, thanks Anh Tran Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7097 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