I managed to sort it out using this code: var fldDate = this.getField("DOB").value; var strDate = "12122004"; fldDate = fldDate.toString(); app.alert("Field Date is " + fldDate + " and the type is : " + typeof fldDate); app.alert("String Date is " + strDate + " and the type is : " + typeof strDate); var fmtDate = util.scand("ddmmyyyy", fldDate); app.alert("Print this is scand date: " +fmtDate); app.alert("THis is printd date: " + util.printd("dd/mm/yyyy", fmtDate));It became apparent that the da...

My issue is that this.rawValue always seems to be empty?

Well I am doing this in Acrobat, but I don't think that should matter should it?Acrobat still has a validate event. I have also tried in the "On blur" event.

Even app.alert(this.fieldname); is undefined....

Geckoz100‌ I really like what your code does, or should do but I cant get it to work.If paste the code into a custom validation script or even a on blue event for a date field nothing happens.I watched the value of newDate = this.rawValue but it is always undefined?What am I missing?Cheers-Al

Reading more and more.Its worth pointing out that I am on Windows XP. Office 2007 and that the users submitting the form are all on the same LAN.From my reading so far to submit the form on different computers across the LAN they would all need the ODBC connection setup? Cheers-Al

HiI dont have a answer for you but want to do exactly what you are doing. Can you tell me the code to Add the record and your settings for the ODBC connection to excel?Thanks-Al