set dateformat mdy declare @datevar smalldatetime set @datevar = 'select getdate()' select convert(smalldatetime, @datevar, 101)
How come this is not working. I am trying to get the current date stored in a variable in a mm/dd/yyyy format. Please Help. Joshua Tipton ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
