Hello all,
I am currently using crystal 8.5 and am trying to create a delivery report.
This report will be printed everyday. However, it needs to retrieve information from 11:46am the previous day through 8:45am today. As far as, Monday - I need to have it from 11:46am Friday to 8:45am Monday.
Obviously, this can be solved easily using prompts or setting up the parameters manually. However, I'd like to set this up so that my users don't need to do anything other than pressing the button and the report automatically prints the information based on that parameter.
I figured out on how to do this based on days using DayOfWeek function. But I can't simply get how to get the time correctly. Any advice will be greatly appreciated. Thanks in advance.
I am currently using crystal 8.5 and am trying to create a delivery report.
This report will be printed everyday. However, it needs to retrieve information from 11:46am the previous day through 8:45am today. As far as, Monday - I need to have it from 11:46am Friday to 8:45am Monday.
Obviously, this can be solved easily using prompts or setting up the parameters manually. However, I'd like to set this up so that my users don't need to do anything other than pressing the button and the report automatically prints the information based on that parameter.
I figured out on how to do this based on days using DayOfWeek function. But I can't simply get how to get the time correctly. Any advice will be greatly appreciated. Thanks in advance.