Hey all,
Just ordered the book from Amazon, but in the meantime I have a problem I cant solve with my limited abilities.
I've been using Crystal for about 6 months now, and Ive been working on this little problem on the side for a while.
Where I work, a day runs from 11pm to 11pm rather then midnight to midnight (which is how Crystal sees a standard day, which makes sense of course). I have a labor report that looks at the previous day's labor. My issue is that the 3rd shift here runs from 11pm to 7am so when the report runs, it only picks up 7 or the 8 hours they worked.
Is there a way to make Crystal look at the previous day as 11 to 11? or is there a formula I could use to maybe pull the previous 24 hours, and then set up the report to print at 11:00pm to catch the time im looking for?
I tried using something like "TimeVar in Range" but I couldnt figure out what the rest of it should read. (im honestly not great with formulas yet)
Any ideas?