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...
that refers to this.rawValue - which I would assume returns the
unformatted value of the field that has focus?The problem is that if I
try to debug the value for this.rawValue it is always undefined.Lets say
code:app.alert("The value is: " + this.rawValue);I always get undefined
no matter what...
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
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
Hi All,I have a PDF form that I want to create in LC Designer and
distribute across our company. Unfortunately the enviroment I am in
means sometimes getting things changed and past our security people is
hard.The form will have a submit button, and ultimately the data from
the form really wants to go into a Access database where some reports
can be generated. This could be hard getting I&T to allow ODBC
connections. Could this also be done in excel?I watched this