BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Time Frame Report - Help Needed


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
ROCKO5960
Forum Member
Forum Member



Joined: 30 Sep 2019

Posts: 5



PostPosted: Thu Oct 10, 2019 9:51 am 
Post subject: Time Frame Report - Help Needed

We are currently running one of our reports with "BegActDate = <[m]Sunday Last Week;yyyy-MM-dd>" & "EndActDate = <[m]Saturday Last Week;yyyy-MM-dd>" The report runs great but when we have a job that runs until 4 am on Sunday morning, our production data gets cut off at 12 am-midnight on Saturday. Is there a way to run the report from 4:01 am Sunday to 4:00 am the following Sunday?
Back to top
ROCKO5960
Forum Member
Forum Member



Joined: 30 Sep 2019

Posts: 5



PostPosted: Thu Oct 10, 2019 1:49 pm 
Post subject: Re: Time Frame Report - Help Needed

I am new to this site so any advice would be greatly appreciated and if I am doing something wrong please let me know. Thanks!
Back to top
richardcottave
Principal Member
Principal Member



Joined: 30 Mar 2006

Posts: 305



PostPosted: Fri Oct 11, 2019 8:00 am 
Post subject: Re: Time Frame Report - Help Needed

If your date field is a datetime data type you should be able to run it for that date time period.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0325 seconds using 17 queries. (SQL 0.0054 Parse 0.0009 Other 0.0263)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo