All the database and table permissions seem to be the same in the two databases. All are "Public".

I am using Cold Fusion and MS-SQL, and will just have to edit the field before display.

function blankdate(a){

 var xdate = null

 a.value=xdate

}

<input name=StartDate    size=12

  onclick = "blankdate(this)" ondblclick = "newdate(this)"

  value = '#dateformat(tempdate,"dd-mmm-yyyy")#'

  ondblclick="newdate(this)">...

Thanks AJ

That is what I do now but I then have to edit the redisplay of the field as the users are confused when they see the 1900-01-01 date.

Just wanted...