Service Desk Practitioners Forum
cancel

filter data exchange export by created date

Highlighted
JW3
Respected Contributor.

filter data exchange export by created date

Software: OpenView ServiceDesk 4.5 (SP7)

I am successfully using data exchange to mass-create Configuration Items from a text file. Now, I wish to export those entries to verify they were imported successfully.

To shorten my list, I am trying to filter by the created date. The line in my export configuration INI file is as follows:
CONDITION=[CREATED]>'11/10/10 12:00:01 AM'

When I run the export, I get 'not a valid month'

Using MSAccess to query the table directly, it shows the above formatting is (supposedly) correct.

Any ideas ?
Jeremy
3 REPLIES
The Pike
Acclaimed Contributor.

Re: filter data exchange export by created date

I'd start by checking the datetime format shown in the SD database and in the SD client.
JW3
Respected Contributor.

Re: filter data exchange export by created date

I found a workaround.

Thanks, Pike.
JW3
Respected Contributor.

Re: filter data exchange export by created date

Workaround found.