• Tried using the Query that you have given,It return me Date as

    2007-10-29 00:00:00.000 .Which is in YYYY-MM-DD HH:MM:SS format.I need the Date in MM/DD/YY.

    Hope someone could help me out on this

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]