Deleting the earliest date

1

Hi

I am using the following sql script to delete data from a table if settle date is earlier than valuation date.

delete from [dbo].[BNYUKLPPIExchangeTable] where [Settle Date] < [Valuation Date].

it keeps deleting 1 row that should be deleted. any reason why this would happen. I ahve attached a pic of the dates. The dates are inmm/dd/yyyy format.

image

dates
dates1152×720 10.9 KB

2

You don't even bother to tell us which is the Settle Date and which is the Valuation Date. Are we somehow supposed to already know that??

Are the columns defined as dates for as varchar (or int or something else)?

1 Like
3

Here are some tips about how to help others help you.