If file is not to big, you can STRTRAN empty dates to nulls.

STRTOFILE( STRTRAN( FILETOSTR("test.txt"), "/  /       :  :", "Null"), "Testnull.txt")

>We are using the following command to create the text file for a SQL bulk insert:
>
>

>Copy To < filename > Delimited With "" With Character "|"
>

>
>We need to be able to propagate nulls for datetime into the SQL but these are being converted to empty datetimes in the text file.
>
>We can change nulls to a bogus date like {12/31/9999 12:00:00 AM} and reconvert to null once the data is brought into SQL.
>
>Is there a way to preserve the null values as part of the copy to?
>
>TIA