• If you want just the date then you should use DT_DBDATE not DT_DBTIMESTAMP and also don't forget to change the data type.

    I am assuming your output is a table. If so, how is the field defined. That will make a difference as to how the value is displayed even though you might just move 2009-10-23 for ex. If you want '0' to be stored in the table, it is not going to work if the field is defined as a date field. If you can't change the field definition to string on the output table, you may want to consider moving a default date.

    Peter