I use a purchase order report that utilizes a field called 'po.orderdate'. Is it possible to create two fields in the report header that's based on the 'po.orderdate', that shows the dates of the beginning and end dates?

I'd like to do something like this:
Report date from (beginning date) to (end date)

Thank you

Edited by jgarner - 20 Jul 2016 at 11:50am

Thanks for your suggestion. However, it's been quite a while since I've used CR, and I have a couple of questions.

I've used the Select Expert to specify the date range. Here's what is in the formula:

{PO.ORDERDATE} > DateTime (2015, 01, 01, 0, 0, 0) and
not ({PO.STATUS} like ["CAN", "REVISD"]) and
{PO.DESCRIPTION} like ["*Locker*", "*LOCKER*", "*locker*"]

As I mentioned, I'm terribly rusty with CR at the moment, and am wondering where and with which tool would I use your suggestion MINIMUM(po.orderdate) and MAXIMUM(po.orderdate)? In a formula or parameter field?

Edited by jgarner - 20 Jul 2016 at 12:22pm

Solved it with the Running Total Field. Thanks for your help

You are absolutely correct with mentioning that using an RT doesn't function correctly in headers, as I was having issues the more I worked with it.

I have put to use your formula. In order to eliminate errors when saving it, it ended up like this:

"Report Date From "+ totext(MINIMUM({PO.ORDERDATE}),"mm/dd/yyyy")+ " to " + totext(MAXIMUM({PO.ORDERDATE}),"mm/dd/yyyy")

I tested this on a 2-page report that didn't have a lot of data. The earliest date on my report is 10/23/15 and the latest date is 7/15/16.

However, when I bring the formula into the header, it looks like this:

Report Date From 39/23/2015 to 56/15/2016

Any ideas why it would show up like that? In the Format Editor / Date and Time, I have my dates formatted as 03/01/1999

Also, I am using the Select Expert to filter my dates (PO.ORDERDATE) as 'is greater than 1/1/2015 12:00:00AM

Edited by jgarner - 21 Jul 2016 at 4:54am

Thanks for the correction. I would never have guessed. I really appreciate your help with this, and this question has been resolved!.

Thanks again.