arsdoc delete command issue

[fnb4321]

 I am having a brain fart using the arsdoc delete command.  I know I must be missing a quote or something but I have tried a couple of variations and can't get it to work.  I am getting either the SQL0401N or the SQL0180N error.  The command I am entering is below..  What am I missing? The IDate is the AppGrp database name for the Index Date/Time Stamp and I got the values using the arsdate -z command.

arsdoc delete -u userid -p passwd -h ondemand -f "T E S T  Statements" -v -G TSTSTMT -i "WHERE AcctNo='123456789' AND IDate BETWEEN 1487930400 AND 1487934900"

[Justin Derrick]

Is the account number field a string, or an number?  (No quotes on numeric fields.)  Also, double-check your date field to see if it's a date or date/time field.  Date fields will have numbers between 1 and 36525, and date/time fields will have much larger numbers, provided the document you're looking for isn't before 11am on January 1st 1970.

Finally, I think the between operator needs parenths...
   

Code: [Select]

BETWEEN (1487930400 AND 1487934900)
-JD.