Display data for previous day 1

[tgraves8]

This might be a simple question but I have not had any luck finding the answer. I need to be able to run a report and have it display the results for the previous day.

The field I have to work with is a date time field. I do not want any prompts.

I was researching the datepart but can't seem to figure out how to make it work. I have not tried any formulas yet.

Thank you for any assitance you can give.

Tim

 

[synapsevampire]

Try Report->Selection Formula->Record and place:

{table.date} = currentdate-1

-k

 

[tgraves8]

That does not seem to work for this. Maybe since it is a date time field

 

[lbass]

Try:

{table.datetime} >= currentdate-1 and
{table.datetime} < currentdate

-LB

 

[synapsevampire]

It should work, check the Database->Show SQL Query to learn what is being passed.

-k

 

[tgraves8]

That did work, I had to recreate the report. I was working with an older report that someone else made. Once I started over the currentdate - 1 worked.

Thank you