SetRange with Date

arindam

Hi Guys,

Merry Christmas in advance !!!!

I am having a simple problem. In my table I have a date type feild. From my search from I need to list all data within a date range.

I am using Setrange function of Navision. Can you please tell me what syntax shall i was trying with the syntax :

SETRANGE(DocDate,>=strStartDate & <=strEndDate);

DocDate is date type , also strStartDate and strEndDate are date type.

Please help.

Thanks and Regards,
Arindam

NaviDev

If you are filtering with range you can use either setrange or setfilter.

ex.

SETRANGE(DocDate, StartDate, EndDate);

SETFILTER(DocDate, '%1..%2', StartDate, EndDate);

arindam

Thank you.

This solves my problem