Skip to Content
author's profile photo Former Member
Former Member

How Do I Get Results From Data Entered Yesterday

How can I specify data that was entered Yesterday for a report? The report is run automatically so I can't hand enter yesterday's date each time it's run. I have been digging through the Help Files and the closest I come up with is 'All Dates to Yesterday'. Any advice would be greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 03:24 AM

    The formula for "Yesterday" should be ...

    DateAdd ("d",-1 , )

    Then your selection criteria would be ...

    {Specific Date} <= {@Yesterday}

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 03:47 PM

    There is a function called as CurrentDate in the formula fields... you can use this column to yesterdays date... and you dont have to manully change it

    happy reporting

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.