• Track the metadata in the flow and determine where you switch from DBDate to String (or if you even do).

    If you don't, and it's DBDate from beginning to end, the date has never been formatted, it's being formatted for outbound (internally it's a Julian value). You'll have to include a Derived Column between the beginning and the end, convert the Datetime to a String, and format it using datepart (No, it's not fun, and no, there's no easy way, it's going to be ugly) to the exact way you want it to look.

    Either that, or convert it to string using CONVERT( VARCHAR(10), column, 101) on it's way out which will also strip off the time component.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA