How to modify date in code for a standard report?

(0) Share

Report

Posted on by jasontl

275

Hey all,

I have a question here on how to modify in coding for a standard NAV report (ID: 111 Customer - Top 10 List).

I need to code in the Date Filter parameter such as it becomes my current month-to-date. So for example, my Work Date for today is 30/07/16.

The date filter, when user opens up the report, should be something like "01/07/16..30/07/16"

If work date is 05/08/16 for example, the date filter should then be shown as "01/08/16..05/08/16"

I am trying to code in the 2nd screenshot below at Report Options Page - Designer but seems the desired result does not come out. Can anyone provide me some idea or hints on the code to use?

Thanks in advance

Cheers

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ashwini Tripathi 4,624 on at

Like (2)

Report

RE: How to modify date in code for a standard report?

RequestPage->OnOpenPage Trigger write:

Customer.SETFILTER("Date Filter",'%1..%2',DMY2DATE(1),WORKDATE);

Was this reply helpful? Yes No
jasontl 275 on at

Like (0)

Report

RE: How to modify date in code for a standard report?

Thanks Ashwini

Your code works perfectly.

Cheers

Was this reply helpful? Yes No