Crystal Datetime to and from query

Posted on 2014-07-15
Last Modified: 2014-07-15
I have the following query i can not get to work.

{CurrentAssetReadings.ReadingDateUTC} in DateTime ({FiscalPeriods.BeginDate}, 00, 00, 00) to DateTime (currentdate, 06, 00, 00)
Question by:kelsanit
    LVL 100

    Expert Comment

    What isn't working?

    Where is that?
    Is it in the Record Selection?

    What data is in the field?


    Author Comment

    using the following formula and get "A time is required here" for this part of the formula DateTime (currentdate, 06, 01, 00)

    Using this in a running total evluate section

    {CurrentAssetReadings.ReadingDateUTC} in Date ({FiscalPeriods.BeginDate}) to DateTime (currentdate, 06, 01, 00)
    LVL 100

    Accepted Solution

    Try it this way

    DateTime (currentdate, Time(06, 01, 00))


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now