Filter Business Partner with CreateDate / UpdateDate

[Former Member]

Hello,

I want to get BusinessPartners (OCRD) whose have CreateDate / updateDate between two date?

It is possible?

Thanks a lot!

[Former Member]

Hello freinds

put Varchar(10)

in the place of Dtaetime as like convert(Varchar(10),'01/09/2010',103)

may be yur problem solved

[Former Member]

try to put

SET DATEFORMAT DMY ...... YOUR QUERY

before your select that you mentioned

[Former Member]

Hi,

Try this:

select * from ocrd t0 
where t0.createdate between [%0] and [%1] OR t0.Updatedate between [%0] and [%1]

Thanks,

Gordon

[Former Member]

Hello

Yes it is possible.

select * from ocrd where createdate between [%0] and [%1]

Regards

János

[Former Member]

Yeah, but it's bugging with the updateDate?

This is my Query but it doesn't work when I asign the datareader to the BusinessObject!

SELECT * FROM OCRD WHERE ((OCRD.UpdateDate between convert(datetime,'01/09/2010',103) AND convert(datetime,'31/10/2010',103)) OR ((OCRD.CreateDate between convert(datetime,'01/09/2010',103) AND convert(datetime,'31/10/2010',103))))