DATE VALIDATION dd/mm/yyyy (date field with manual entry)

Well, have you tried just using a palin text field and writing your own validation, key stroke and format scripts?

I just made it a Text Box field and validated the date with Javascript. Of course, I'm an old COBOL programmer and I know how to do that. ;) The user can enter MMDDYY, MMDDCCYY, MM/DD/YY, MM/DD/CCYY or replace the / with a dash (-), dot (.), or space. Javascript has a date function that converts a string to a "date". If the function fails, the string was invalid.

Dear All,



I have serious problem with Date/Time Fields. It seems that Date/Time Fields just DO NOT work properly. I am using Windows XP, with Arabic Language Support Enabled and LiveCycle Designer 7.1.



I am facing all kind of errors/problems with Date/Time Fields. I decided to switch my Regional Settings to English UK and also tried English USA, but still same result.



If I use a plain Date/Time Field, and try to make any data entry during runtime, the input is always converted to format "dd-mm-yyyy" and the numerals are converted to Indian Digits (Arabic/Indian Shapes). And, when I try to use Date Patterns for display, edit and validation, nothing works as per the documentation.



In summary, the Date/Time Fields do not work as per the documentation.



I tried for normal text and numeric fields, they do work as per the documentation. But, Date/Time Fields do not work at all, and all what I get is incorrect display or entry or always I get validation error.



Can some one tell me what is going on ????



PLEASE HELP !



Tarek.

I have the same problem. What java script did you use to check the data

By chance, and not sure exactly what solved the problem of working with Date Fields, I think when I made a small MS Access Table with Date Fields, and exported it to XML with Schema info, and created a connection to this XML/Schema from Adobe LiveCycle Form, then the Data Fields worked properly, but honestly, not sure exactly.



However, in my previous project, I used the functions in FormCalc to convert String input to Date Variable, and do the Validation. You could do that in JavaScript, but it is a bit more difficult.



Tarek.

Not an exact solution. Needs a little work to prevent text characters:

~ works for dd/mm/yyyy; if not that format set field to null.



var DD = parseFloat(this.formattedValue.substr(0,2));



var MM = parseFloat(this.formattedValue.substr(3,2));



var YYYY = parseFloat(this.formattedValue.substr(6,2));



if(DD > 31 || DD < 1)



{



this.rawValue = null;

}



if (MM > 12 || < 1)



{



this.rawValue = null;



}



// if string length not 10 cant be correct



if (this.formattedValue.length != 10)



{

this.rawValue = null;



//look for first /



if( this.formattedValue.substr(2,1) != "/")



{



this.rawValue = null;



}



//look for second /



if( this.formattedValue.substr(5,1) != "/")



{



this.rawValue = null;



}



}

If you check the Adobe documentation pages for LiveCycle Designer there are many documents about creating forms in LiveCycle Designer.



"E" one digit day or week

"EEE" abbreviated day of week

"EEEE" full weekday name

"D" date without leading zero

"DD" 2 digit date with leading zero

"DDD" short day of week text string

"DDDD" long day of week text string

"M" month with leading zero

"MM" 2 digit month with leading zero

"MMM" Short month text string

"MMMM" long month text string

"YY" year as decade

"YYYY" full year



As with JavaScirpt and FromCalc case is important.



More information about date formats is contained in the "Scripting Reference" under LiveCycle Designer's menu bar "Help" option.

Ok is there any way that you can get the DATE FIELD to only accept putting in the date or have the calendar in there, and not have any TEXT or LETTERS in there. I mean is there something I need to click on in Live Cycle to make this happen to where when you click on the date field you automatically get a calendar and can choose a date and cannot have an option to type any letters in? Anyone, please help.

Yes, but you need to set a lot of the optional formatting options for the field using the strings I posted above.



The format fields are CASE dependent!



The order of the date elements is important.

We've done that (MM/DD/YYYY). However we're still getting that we can type in letters in the date and time field and we don't want that. We specifically want only the date. So can you walk me through what I need to do?