Skip to Content

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

Return result within timeframes of several days

Hi All,

I am using CR2008 and designer to create a report. I am having a question regarding timeframe.

I want to return a result within a timeframe in the past several days.

I have a date range and time range parameters for user to specify a date range and time frame within the days. For instance return the results in the past 10 days between 6:30 AP to 4:30PM

I know the below works for a pair of start/end date.

{table.field} in {?Date Range}

I am wondering if anyone know how to create formula in Select Expert to handle the time frame in a date range?

Thanks in advance.

Dennis

Former Member
replied

If you have a date/time field create two new time parameters start time and end time:

Then change your record selection to:

({table.field} in {?Date Range})

AND

(Time ({table.field}) >= {?StartTime} and Time ({table.field}) <= {?EndTime})

Edited by: James Terry on Sep 8, 2008 10:13 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question