Add Method on Conditions Class

[suzreid]

Help!!!

I'm having a real problem trying to use the following piece of code. I don't know if my logic is wrong or what the problem is.

Set BOCond = BODP.Queries.Item(1).Conditions.Add("Dead Patients", "Date of Death", "Between", Me.DTPDateFrom, , Me.DTPDateTo)

Me.DTPDateFrom is a date picker control on a VBA form which is set to date() as the form is initialized.
Date of Death is a date field in the Universe.

Any help is appreciated.

 

[CODEBUSTER]

You need to add the literal "Constant" after each date parameter, thus ....

Set BOCond = BODP.Queries.Item(1).Conditions.Add("Dead Patients", "Date of Death", "Between", Me.DTPDateFrom, "Constant" , Me.DTPDateTo, "Constant&quot

see if that works.

(Im with BO!)