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

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?

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

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

Huh !

What exactly is the goal and find purpose, Mr Argh Tranh ?

(kidding !)

Thanks All,

My problem is a little hard to explain for you guys, my experts, I will solve it later. Anyway, thanks

Anh Tran