Geting Exception while searching on date field

Classic Servoy
1

HI,

I made a sample solution. where i am reducing the foundset using reduce search. But it is giving me exception. :cry:

This is the code.

controller.find();
requireddate = ‘!=’ + dDate +‘|MM-dd-yyyy’;
controller.search();

Thank you

2

You have to format the date to a string.

3

Hi Marcel,

I have tryed this also. but not getting any +ve response.
Search is working with other operator like(>,<,<=,>=). It is only creating problem with “!=” operator.

controller.find();
requireddate = ‘!’ + utils.dateFormat(thestart, ‘dd-MM-yyyy HH:mm:ss’) +‘|dd-MM-yyyy HH:mm:ss’;
controller.search();

Thank you

4

If you want to reduce the foundset you should use ```
controller.search(false, true)


> prem:
> It is only creating problem with "!=" operator. 
> 
> controller.find();
> requireddate = '!' + utils.dateFormat(thestart, 'dd-MM-yyyy HH:mm:ss') +'|dd-MM-yyyy HH:mm:ss';
> controller.search();

To exclude certain values you should use "!" instead of "!=" (just like using a boolean).

Your code seems to be correct to me, do you still get an exception with this code? If so, can you post it here?
5

Hi Joas,

Now It is not givig me exception. but it not reducing the foundset.

controller.find();
requireddate = ‘!’ + utils.dateFormat(thestart, ‘dd-MM-yyyy HH:mm:ss’) +‘|dd-MM-yyyy HH:mm:ss’;
controller.search(false,true);

Thank you

6

Weird, nothing wrong with this code afaik
Can you post your entire script, so that we can have a look?

btw, what version of servoy are you using and what is your OS?

7

Hi Joas,

I am using servoy3.5.2 with windowsXp. I have used this same script in another test solution it is working. Migth something wrong in that solution.

Well!, Thank you.

8

Is the dataprovider of type data?

When it works in another solution there is something wrong in your solutions, database or whatever but not Servoy I guess.

Happy debugging :)

9

Hi Marcel,

I don’t know what’s wrong with that particular solution. I didn’t tell problem with servoy.

Thank you

10

Are you sure that the data you’re looking for exists?

What happens if you perform the search manually? Do you get correct results that way?

11

Ya, It is working while i am performing manual search.

Data is exist in database.