Want to delete DRAFT entries in bulk mode

4 months ago 21

I privation to delete the DRAFT from twelvemonth 2019. How tin I delete successful bulk mode?

Or tin tally a query to delete the DRAFT??

I make the pursuing query. erstwhile I tally query by DocNum, it works But if one adhd posting day selection, it gives mistake "1). [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a varchar information benignant to a datetime information benignant resulted successful an out-of-range value. 'User-Defined Values' (CSHS)" 

What should I do, to tally the query by day enactment option.

DELETE FROM

ODRF
WHERE
--DocNum = '20129';
DocDate = [%0] and DocDate = [%1] ;

Read Entire Article