This function supposes to detect client&#039s short date format and format the date according to client&#039s short date format. I have two servers 1 development server and 1 production server. Both server&#039s short date format is "mm/dd/yyyy". When I connect to my development server formatdatetime() function uses my client&#039s short date format (mm/dd/yyyy) and shows the dates like "mm/dd/yyyy". But when I connect to my production server formatdatetime() shows dates like "mm/dd/yy". <BR><BR>Any idea why this is happening?<BR><BR>Thanx.<BR>