3

How to use the query below in conditional split , nxdt is a date column; it has values like 11/30/0002 00:00:00.000000. Hence used below query to filter out and need to use the same in my package 

SELECT *
FROM VLCVehicle 
WHERE  DATEPART(year, nxtDt) < '1753' OR DATEPART(year, nxtDt) > '9999'
Dale K
  • 25,246
  • 15
  • 42
  • 71
user3073172
  • 41
  • 3

1 Answers1

1

You can use the following expression:

 DATEPART("yyyy", [nxtDt]) < 1753 || DATEPART("yyyy", [nxtDt]) > 9999
Yahfoufi
  • 2,220
  • 1
  • 22
  • 41