Posted by sql guy123 on 11/29/05 00:07

HI,

I'm pretty new to MS SQL,

My problem is setting ....

=Format$(Date(),"mm" & "/1/" & "YYYY")

(Which is from my MS ACCESS database)

as my default value in MS SQL. How can I do this since format() does
not seem to be a function that is in MS SQL. The above function works
great in MS ACCESS, but not in MS SQL.

thanks

• Next in forum: Re: difficult summing query
• Prev in forum: Re: Bulk Import with header in text file
• Thread view: Format() Function in MS SQL

[Reply to this message]