Add Slashes for Date Field

[KC_MEDS]

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?

[Raybaudi]

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

[KC_MEDS]

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

[LaRetta]

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.