• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

Crystal - Formula help with date range

I have a report where I need to specify a data range in a running total and not sure how to write.

Need to pull all data < currentdate  and also include currentdate items where entertime is less than 6:00am

Example:
Production pounds < currentdate = 20,000
currentdate records entered before 6:00am = 2000

I want to have a single statement that will capture the 22,000 total.
0
kelsanit
Asked:
kelsanit
  • 2
  • 2
1 Solution
 
mlmccCommented:
You should be able to have it evaluate when
   {YourDateTime Field} < DateTime(CurrentDate, Time(6,0,0))

mlmcc
0
 
kelsanitAuthor Commented:
Need to make a change.  The current field {receiptdate} has the same time staple of 12:00:00am on all records. There is another field called {time} that does have the correct value.  How would you write this using both fields to accomplish goal?
0
 
mlmccCommented:
I suspected that but wasn't sure

Try this

  {Your Date Field} < CurrentDate
OR
(
     {Your Date Field} = CurrentDate
    AND
    {Your Time Field} < Time(6,0,0)

Open in new window


mlmcc
0
 
kelsanitAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now