Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Two date fields in one report

dear all,

I have created a report which filters records according to statuses. The problem I am having is that two different distinct count fields need to filter by using two different date fields from two different tables. For example

DistinctCount() - this needs to look into Order header date created field

whereas

DistinctCount() - this needs to look into Lab Credit Date created field.

Order header is a table, date created is a date field

LabCredit is a table, date created is a date field

My question is, how can I use both date fields to filter my reporting records.

I have used the following under Report Selection formula but it produces results from only Lab Credit Field and 0s from the FOC field.

{lab_credits.credit_date} in currentdate to currentdate OR
{order_header.date_entered} in currentdate to Currentdate

There is something wrong somewhere and I don't know where.

Any ideas?

Regards

Jehanzeb

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question