Question: ```
DELETE FROM BIZ 
WHERE [Orgnl_Cmpltn_Date]
      BETWEEN '2014-02-31'  AND '2014-04-01'

```

This is the `DELETE` statement I wrote. There is an error that says: 

> 
> Conversion failed when converting date and/or time from character string.
> 
> 
> 

I know I have to write the correct date format, but I am not sure how that goes. 

This question has not been answered elsewhere because the answers I saw did not specify date format (in the context that I am asking for)

Answer: 
Use this instead

```
DELETE FROM BIZ
WHERE [Orgnl_Cmpltn_Date] >= '2014-02-28'
AND [Orgnl_Cmpltn_Date] <= '2014'04'01'

```

I don't know if this matters, but February has only 28 or 29 days.
You can use the following code:

```
DELETE from Tabel_Name WHERE Date BETWEEN CONVERT(datetime,'01/01/2001',103) and CONVERT(datetime,'31/12/2001',103)

```