Wednesday, September 19, 2007

Format date fome the database (not front end)

(cast(year([Due_Date]) as varchar)+'-'+cast(month([Due_Date]) as varchar)+'-'+ cast(day([Due_Date]) as varchar)) AS [Due_Date],

No comments: