[SOLVED] Retrieve data for the last 10 days report

Hi,
I'm new to the App studio(co-op student) and as a first task I have to create a report that retrieve some date, but the date need to be for the last 10 days. I'm stuck in the part how to display the last ten days data?
thank you!

This message has been edited. Last edited by: FP Mod Chuck,

WebFocus App Studio
V8201

Posts: 23 | Registered: September 18, 2017

FP Mod Chuck

Virtuoso

posted

Hide Post

Hi Badr.A

Welcome to Focal Point. This is a great place to get answers to your development questions.

You will need to set a variable to use in your WHERE statement.

This dialog manager code will go before the actual report.


-SET &&P10DAY=AYMD(&YYMD,-10,'I8YYMD');

Then your WHERE statement will be


WHERE DATEFIELD GE &&P10DAY

DATEFIELD will be the name of the date field you want to compare to.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats

Posts: 2127 | Location: Customer Support | Registered: April 12, 2005

Ignored post by FP Mod Chuck posted

Show Post

Badr.A

Member

posted

Hide Post

Thank you Chuck Wolff,
I need to confirm what I did I added:
-SET &&P10DAY=AYMD(&YYMD,-10,'I8YYMD');
To the very top of the TEXT EDITOR, then I create an advanced where clause:
START_TIME GE &&P10DAY
START_TIME: is the name of the field in need to compare with.
what if I need to show the last 5 days,would I change only the numbers from 10 to 05?

thank you!

quote:
Originally posted by Chuck Wolff:
Hi Badr.A

Welcome to Focal Point. This is a great place to get answers to your development questions.

You will need to set a variable to use in your WHERE statement.

This dialog manager code will go before the actual report.

-SET &&P10DAY=AYMD(&YYMD,-10,'I8YYMD');

Then your WHERE statement will be
WHERE DATEFIELD GE &&P10DAY

DATEFIELD will be the name of the date field you want to compare to.