June 3, 201015 yr Newbies If I want the auto populate the slashes in a DOB field how would I use the Object Vailidation triggar script to help me convert those dates to an eight figure date?
June 3, 201015 yr Set Field [ DOB ; Date ( Middle ( DOB ; 1 ; 2 ) ; Middle ( DOB ; 3 ; 2 ) ; Middle ( DOB ; 5 ; 4 ) ) ] BTW: you have to trap to empty DOB and to its Length
June 3, 201015 yr Author Newbies Sometimes the data placed in that field is 6 digit date or a 7 digit date, example 1112000 I don't know if the person means 01/11/2000 or 11/01/2000 so I thought if I build some kind of trigger script based on object vailidation if could tell me what the put in and then I can build a vailidations that indicates if script is correct...just not sure how to get there
June 3, 201015 yr 1112000 That is not a valid date. I suggest you use a REAL date field. You can set up (at the OS level) whether you want slashes, dashes etc and whether you want leading zeros. By using a text field to hold your 'dates', you are opening yourself to many problems ... "I don't know if the person means 01/11/2000 or 11/01/2000 " ... being just one of them.
Create an account or sign in to comment