Date/Time Problem

HCL Domino Domino Forum
1

Hi

I am writing the following script. I am facing some problem with putting search formula. Here is the script.

Dim archdate As New NotesDateTime(profdoc.ArchiveDate(0))

In my search formula I want to put archdate. If I directly pass that it is not working.

SearchFormula1= “(form = ““COL”” | form = ““bonus””)& DateofOffer <= @TextToTime(‘08/16/2007’)”

How do I do that?

Thanks & Regards

Sanjay

2

Subject: Date/Time Problem

I got…here is the answer.

archdate = profdoc.ArchiveDate(0)

SearchFormula1= “(form = ““COL”” | form = ““bonus””)& DateofOffer <= @TextToTime(‘archdate’)”

3

Subject: RE: Date/Time Problem

Are you sure about that? It doesn’t look to me like it would work. The word “archdate” is part of your string literal. There’s no reason this would be associated with a variable in your program.

archdate = profdoc.ArchiveDate(0)

SearchFormula1= {Form = “COL” : “bonus” & DateofOffer <= [} & archdate & {]}

  • Andre Guirard, IBM/Lotus Development

Useful blog: Best Practice Makes Perfect

For faster answers, be C R I S P Y