Skip to main content
Sep 12, 2007 6:20 AM UTC

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

Is there a way to stop people filling in date fields manually?

since there is a calendar, there not only is no need for manual entry but it also avoids input error..



When I try to validate a date, it will either accept the manual date, or the calendar date but never both.



Does somebody have a solution for this? .. either to validate both the calendar date & manual entry (entered in dd/mm/yyyy)



Or

to prevent users from typing inside the date field (& use the calendar!)

(or prevent them from typing anything other than dd/mm/yyyy)



('ve tried regular expressions but it does not accept the value from the calendar)



Thanks hopefully!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

33 replies

Level 8
Mar 18, 2008 1:16 PM UTC
Well, have you tried just using a palin text field and writing your own validation, key stroke and format scripts?
Translate
Mar 31, 2008 1:08 PM UTC
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.
Translate
tarekahf
Level 8
Sep 30, 2008 11:11 PM UTC
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.
Translate
Oct 22, 2008 9:58 PM UTC
I have the same problem. What java script did you use to check the data
Translate
tarekahf
Level 8
Oct 22, 2008 10:20 PM UTC
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.
Translate
Feb 10, 2009 6:10 PM UTC
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;



}



}
Translate
Level 8
Feb 10, 2009 6:38 PM UTC
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.
Translate
Feb 19, 2009 5:35 PM UTC
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.
Translate
Level 8
Feb 19, 2009 7:39 PM UTC
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.
Translate
Feb 19, 2009 7:59 PM UTC
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?
Translate
Nov 26, 2009 2:28 PM UTC

Hi - did you ever get an answer for this - to prevent users from entering text into a date field and using ONLY the calendar?
Regards,

B.

Translate
Level 3
Aug 14, 2013 3:58 PM UTC

Can you cut out all entry ability except calendar? I have hundreds of people entering the days in many ways which is messing up the field.

Translate