Date Filter as range on the request page

(0) Share

Report

Posted on by Community Member

Hello community,

I'm trying to apply filters to a custom report. I'm struggling with Date filter as range. In the past what I have done is create two global variables: StartDate and EndDate both as Date variables. Then I simply apply a SETRANGE filter: SETRANGE("POSTIND DATE", StartDate, EndDate) and that works ok.

However, NAV 2013 R2 has this behavior where you can simply tipe 01052015..31052015 and it will apply a date format. That what I'm tryint to accomplish. I already know that I would have to use SETFILTER instead of SETRANGE to start with.

Any suggestions or any directions to the right place would be greatly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Will,

If you want to use that format you have to use SETFILTER

Example:

SETFILTER("Posting Date",'%1..%2',StartDate,EndDate);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your answer Suresh, what I'm trying locates on the request page. Below more detail information.

As you can see in the picture above, I'm trying to type the dates in range like 01052015..31052015 to only request one input from the user. This to avoid having multiple boxes asking just for dates.

If I do this on the G/L Register page i get this:

Navision complety understand that I have input two dates. That what I'm trying to accomplish if possible.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

What is the source expression for the Request page Date Filter, is it a variable if so what is the datatype ? If the data type is Date then it should be good, i think there may be validation added on the validation of the field on the request page to check the format. Please check if there is any code.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,003 Super User 2025 Season 2 on at

Like (0)

Report

Please check the Data type of the Dates variable. It should be of Type Text and you have to use GETRANGEMIN and GETRANGEMAX functions to get those range of dates.

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (0)

Report
Hello,

You should find a specific function in codeunit 1 specifically designed for this:

Check this code:

Variables used:

AppMgt: Codeunit 1

FormatTextDateFilter(TxtDate : Text[30])
AppMgt.MakeDateFilter(TxtDate);

MESSAGE(TxtDate);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I keep getting an error when I try your solution...

I'm using NAV 2013 R2 and using NAV Development Enverironment to design my Reports. This is what I have done so far,

Declared a Global Varible under C/AL GLobals called TxtDates wich is a text DataType with a length of 50

On my request page I have reference this Global variable as a field Type...

Finally, I go into the C/AL code for the request page and type your code

and thats when I get the error. I'm sorry if not making any sence and not understanding your answer. I have been working with NAV Development Environment for two weeks now. Thanks for taking time out of your day to help out.

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

deleted

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,003 Super User 2025 Season 2 on at

Like (0)

Report

Did you try without using Codeunit 1?

Just a text variable and insert the date.

get the dates using GETRANGEMIN and GETRANGEMAX ?

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (0)

Report

Hello Williams,

FormatTextDateFilter is a function I created. You can use the code inside it. If you want to use the name of the function that works too :)

This way TxtDate can have the value '010101..311201' and it will be transformed to what you expect.

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (0)

Report

Let me attach a screenshot with the example:

Function:

Call the function from the object:

Was this reply helpful? Yes No