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] ;