How to use dumpspecified with a datetime field ?

[danishgambit]

Afternoon,

hoping someone might be able to help me by offering some advice on using the dumpspecified option of the proutil command against a datetime field.

I've had no problems previously running it against a date field, but the particular table I'm trying to dump is a datetime field and so far I've had no joy using this field. Assuming it's possible, it must be a syntax-issue, so if anyone has any experience of doing this, I'd certainly appreciate their input.

TIA,

DG.

 

[cj_brandt]

proutil MUTUFUND -C dumpspecified ThreadMstr.CreateDT LE "01-01-2001 01:01:00:000" .
Using index 2301 which is ThrdMstrCode for the dump of table ThreadMstr . (10035)
Dumped 2 records. (13932)
Binary Dump complete. (6254)

You should get an error like below if your syntax is wrong
ERROR - use MM-DD-YYYY HH:MM:SS.SSS for datetime format (12103)
Binary Dump failed. (6253)

 

[danishgambit]

Afternoon cj_brandt,

thanks for that. I'd missed out the decimal seconds in my string so I've added the ".000" and it's working.
Excellent.

Cheers,

DG.