I am using SQL server 2000 with data from as/400 dts transfer. I have a date field with julian dates that look like this:
Any idea how to convert this date to regular date in display in frontpage created databse wizard results. I have tried to tweek SQL drive in odbc admin. no luck as of yet.