This results in zeros being passed into the DateValue function.I was going to suggest the STOD function instead but it to throws an error with an empty string and also with a string of 10 spaces.Instead of having two fields I would have only the date type. Strange that stod is not throwing an error for you.When you start a new record the DBBDOB field is empty.
![sc drivers license barcode type sc drivers license barcode type](https://www.l-tron.com/wp-content/uploads/2013/12/4910LRquickview.jpg)
RichardEDIT: I see you got it working already. When that happens, the only way to get out of the table is to forcibly close out of the program.The expression to convert the date seems to be working correctly, so I don't know why it keeps saying that the month is out of range, but if I get rid of the expression, the errors go away. Next to it, I created another field called 'DOB,' and I'm using the below expression to convert the string to a 'normal' type date:DATEVALUE(VAL(LEFT(DBBDOB,4)),VAL(SUBSTR(DBBDOB,5,2)),VAL(SUBSTR(DBBDOB,7,2)))Again, it works correctly, and the DBBDOB string of 19560115 converts correctly to, but when I try to start a new record, I immediately get an error message that says: 'MONTH IS OUT OF RANGE.' Then if I try to close out of the table or delete that record, I get another message that says 'ENTER MUST BEGIN FIRST.' And then I'm stuck, because it won't go past that point. Unfortunately, there is no current web standard for key events (unfortunately). It could be done, but each of the 5 most common browsers all handle key events differently (some in major ways, some minor).
#SC DRIVERS LICENSE BARCODE TYPE TRIAL#
(which incidently the trial version has a working function feature that has a test mode that allows you to see all characters that the scanner sends, even special keys) within Alpha Five.Doing it for the web side requires handling a javascript key event, which Alpha does not have.
![sc drivers license barcode type sc drivers license barcode type](https://www.gannett-cdn.com/presto/2019/08/28/PCIN/e9aac56b-3492-447f-abc2-99f9a081cabf-DLOhio3.jpg)
If the cursor is not where you need data, the barcode characters will be entered wherever it is.If you could get the cursor to move to a particular field or dialog box 1st, then the data entered can be used to fill in data or invoke a find, or whatever you needed to be done.This is exactly what my does for the desktop side. There are a myriad of character parsing functions that are usable in Alpha, and there is nothing special here.The real issue, is that a barcode scanner will scan the data into where ever the cursor is.
![sc drivers license barcode type sc drivers license barcode type](https://www.dmvcalifornia.us/wp-content/uploads/2021/02/south-carolina-dl.jpg)
Hi Rich,Parsing a barcode, yours included, is relatively trivial.