Date Forumla Crystal XI

Posted on 2009-02-24
Last Modified: 2012-06-27
Hi -
I want to create a formula in Crystal XI that counts ten days back from the current date.
Thanks, Stacy
Question by:stacydr
    LVL 10

    Accepted Solution

    To just make a formula that displays the date 10 days ago, you'd so something like:

    But I imagine by "count back" you mean selects records that are 10 days back?

    If so, try this as a record selection formula (you'll have to choose the field from your DB that has the date you're trying to compare to):

    {mydatabase.mydatefield} = DateAdd("d",-10,CurrentDate)

    If you were looking to select all records with activity in the past 10 days, you might try something like:

    {mydatabase.mydatefield} >= DateAdd("d",-10,CurrentDate)

    Hope this points you in the right direction.
    LVL 2

    Author Closing Comment

    thanks so much -- you were absolutely right -- the third formula was the one I was looking for!! thanks...Stacy

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    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

    22 Experts available now in Live!

    Get 1:1 Help Now