November 18, 200718 yr Hello Again guys, need help with this calculation/custom function please. The output I am trying to achieve in a calculation is listed below 15-40500-72000-31500-project title 16-25200-72000-46800-project title 17-25200-72000-46800-project title 18-25200-72000-46800-project title 19-25200-72000-46800-project title 20-25200-42300-17100-project title I have created a database with a start date and time, end date and time. The start date and time field produces line number 1 which is 15-40500-72000-31500-project title and the end date and time produces the last line which is: 20-25200-42300-17100-project title I need a calculation to produce the filler dates in the range, typically the values 16-25200-72000-46800-project title 17-25200-72000-46800-project title 18-25200-72000-46800-project title 19-25200-72000-46800-project title it is only the first bit of data that needs to change depending on how many days the user chooses. The 25200-72000-46800-project title will remain the same throughout till the last line. In my example the user chose from 15 of the month through to the 20th of the month. Is this possible?
Create an account or sign in to comment