Options

Webservices DateTime Filter

PhiltooPhiltoo Member Posts: 36
edited 2009-06-22 in NAV Three Tier
I'm trying to create a filter on a DateTime value and then ReadMultiple using webservices. However, I keep getting SOAP errors that "TODAY" is not a valid date?, "t" is not a valid date, when I filter the table using the value DateTime.Today.Date.ToString("MM/dd/yyyy"); I get no errors, but I also get no results even though there are plenty of
records with today's date.

All of these filters seem to work fine within the client, why can't a webservice use filters like "TODAY", "t", or just today's date?

I'm at a loss here, how do I create a filter on a DateTime value so NAV will return records with the Date = today?

Comments

  • Options
    PhiltooPhiltoo Member Posts: 36
    I figured it out, you have to use the range operator. I love how consistent and well documented this product is.
  • Options
    ara3nara3n Member Posts: 9,255
    If you could share a couple of lines of your code, it would help people in future.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.