yafreax Posted October 30, 2000 Posted October 30, 2000 i have a problem in which i need to calculate when five working DATES from any given DATE is. I have a field that is a date ordered field. And i need a due date field to equal five working dates after the date ordered. I haven't had a chance to mess with this too much, but sounds like it would be a wierd calculation (or script, if needed). Also another problem i have a variety of databases that will need job numbers, problem is, the job numbers will not be specific to each database, rather the job number must be unique across all the databases, i need this to be done in a serial number type fasion. what i mean by that is that they need to be uniform. The letter "I" followed by 6 digits. I thought of a seperate JobNumber database, but i don't know how to relate correctly . . . . hmm, any ideas. Jeremy
LiveOak Posted October 31, 2000 Posted October 31, 2000 The dates calculated from one date is an easy problem. How to relate your files depends upon a detailed knowledge of your databases. The first question: If your first field is OrderDate (date) then you could have: NextDate (calculation, date) = OrderDate + 7 This would give you a date equal to the order date plus one week. The other dates would be defined similarly, assuming they are just offsets from the initial date. For the second question, I need to know a LOT more about your files or you need to seek out a consultant for some help. -bd [This message has been edited by LiveOak (edited October 30, 2000).]
yafreax Posted October 31, 2000 Author Posted October 31, 2000 well i understand the date thing, but the problem is that it's working days. So saturday and sunday can't be counted. So if someone ordered on thursday, the due date wouldn't be until thursday ( i guess this is your 7 day thing). I guess i should've thought my question through a little more because it will vary some. I might need a calculation for 3 working days or 7 working days. This is where i would maybe see the problem . . .? i don't know, maybe it is a lot easier than i am making it. Jeremy
Chuck Posted October 31, 2000 Posted October 31, 2000 quote: Originally posted by yafreax: well i understand the date thing, but the problem is that it's working days. So saturday and sunday can't be counted. So if someone ordered on thursday, the due date wouldn't be until thursday ( i guess this is your 7 day thing). I guess i should've thought my question through a little more because it will vary some. I might need a calculation for 3 working days or 7 working days. This is where i would maybe see the problem . . .? i don't know, maybe it is a lot easier than i am making it. Jeremy I actually came across this myself today. Check out www.databasepros.com and do a search for "work day" and you'll find a calculation that does what you need. Chuck
yafreax Posted November 1, 2000 Author Posted November 1, 2000 thanks, just what i needed. Don't completly understand all of the calculation but it works and i'll just revert to the wonderful tool of copy and paste. Jeremy
BobWeaver Posted November 24, 2000 Posted November 24, 2000 For your second problem, if I understand it correctly, I think you need to create one separate file to hold job numbers. Set up a job number field in it as auto-enter serial number etc., and probably a field to identify which database the job number is assigned to. Then when you need a new job number, execute a script in the job number file that creates a new record and assigns it to the appropriate database. You can then copy/paste the job number back into the original database.
H.P. Posted July 9, 2004 Posted July 9, 2004 Hell, took me 2 hours and still didn't finish the formula for calculating work days. 1 min search on here led to a solution that is 10 times shorter than mine
Recommended Posts
This topic is 7432 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