Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 14:30:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, July 27, 2012 08:13 -->

Try this:

     (
     PARTITIONS WHERE
     (! (Start_Date BETWEEN date'2011-02-14' AND date'2011-02-21') OR (Start_Date
     BETWEEN  date'2012-03-07' AND date'2012-03-14')!)
     )

	<Prev	Next>		<<First	<Prev	Next>	Last>>