Db.search date problem

HCL Domino Domino Forum
1

Hi,

I want to search the document within the database by using the mentioned criteria. But while the mentioning the criteria it says “Type Suffix does not match data type: FORMULA.” What can be the error?? Please let me know about this…

Below is the code of searching criteria:

Formula$ =“Form = ““SRDGEN”” & status_4 & Doc_By <> “””+Self-Doc+“”" & Updated_By <> “”“+MPT+”“” & Updated_By <> “”“+Self+”“”& (CreationDate<=@date(“+Cstr(Year(doc.tdate(0)))+”;“+Cstr(Month(doc.tdate(0)))+”;“+Cstr(Day(doc.tdate(0)))+”)) & (CreationDate>=@date(“+Cstr(Year(doc.fdate(0)))+”;“+Cstr(Month(doc.fdate(0)))+”;“+Cstr(Day(doc.fdate(0)))+”))"

2

Subject: Break it down…

Try each item of your search and see what happens. Does it fail on a specific comparison, or does it fail when you put then all together?

Also I would suggest, you use { and } as your string identifier, then you can have something like this:

Formula$ ={Form = “SRDGEN” & Doc_By <> “}+Self-Doc+{”}

Instead of

Formula$ =“Form = ““SRDGEN”” & Doc_By <> “””+Self-Doc+“”"

3

Subject: RE: Break it down…

And first of all make sure, that you didn’t declare Formula before with a different data type. This exact error message is actually mentioned in Designer help.