This works and looks good to me.

declare @date as datetime

select @date = convert(varchar(10), getdate(),101)

print  @date

I am running gaint cursor to see what values and assets need to be reconciled from account, price and assets. then checking market value if exists then insert values in...

This works,

add 1 month, sub days of date

select convert( datetime,right('00'+convert(varchar(2), month(@date)),2) +

 '/' + right('00'+convert(varchar(2), DAY(DATEADD(d, -DAY(DATEADD(m,1,@date)),DATEADD(m,1,@date)))),2) + '/' +

 convert(varchar(4),year(@date)))

I had the problem other way. when importing impoted text but not intergers

eg.

abcd

efgh

ijk

2003

2004

www

2003 and 2004 did not get imported. Used Access to import first then into SQL worked fine.