Dynamics Nav (Navision) webservice ReadMultiple date filter

microsoft-dynamics navision dynamics-nav
Billy picture Billy · Aug 6, 2010 · Viewed 8.5k times · Source

Using the Navision webservices, how can you filter by a date.

i.e. Within a SalesHeader table there is an "ExportedDate". I would like to find all SalesHeaders where the ExportedDate has not been set or were exported on a particular date.

It seems that whenever we set a filter on a date field, then the webservice will either return all rows or no rows.

Answer

jaensen picture jaensen · Feb 17, 2011

This can be done. You have to use the same filter expression as you would use in the Nav Client:

01012011..         would be all dates from 01.01.2011
..01012011         would be all dates to 01.01.2011
01012011..03012011 gets all dates between 01. and 03.

Related questions

C/AL How and where do I start?

I come from a C# background, used to do programming to control all the low-level stuffs (microcontroller, and HW related stuffs). I just changed job and is required to learn programming Dynamics NAV. I have never worked with database-heavy application …

Read More
Navision How to Convert a Text to Option

I have a text variable which I want to convert into a option and set table data with it. How do it convert the variable into a option? Thanks

Read More
retrieve the value selected in optionset field and display ita value in a text field

Could any one please help me in displaying an optionset field value in a text field..? I want to retrieve the value selected in optionset and display the same in a text field using plugin.. Iam writing this plugin on "…

Read More