>if the date is of dd/mm/yy i 've to return dd/mm/yyyy
> (dd/mm/yy is only one format,and assuming i don't know the format )
>then how?
Rahd,
If you leave the data alone and don't take it apart, using GOMONTH() as both Cetin adn I have suggested, then the return date will be the saem data format as the date you received. The date only changes formats with the SET DATE TO command and that only changes the way the date is displayed.