<div>
You have it set as a Date data type and not a Char data type in SQL, correct?
</div>


You have it set as a Date data type and not a Char data type in SQL, correct?

<div>
There is onyl one date type option to change it to in sql and that is smalldatetime. it fails to do this change when I go to save the change made in table design.
</div>


There is onyl one date type option to change it to in sql and that is smalldatetime. it fails to do this change when I go to save the change made in table design.

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
101087<br />
<br />
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.
</div>
</div>


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:

101087

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.

Julian Date Coversion

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.