Use of left, right and mid does not give the desired result
You might be close with that, but I can't see what you tried from here!
I tried DateSerial but couldn't get it to work with 20190610. It needs (2019,06,10) and if you can make 20190610 into 2019,06,10 you should be able to use Right, Mid or Left directly.
Maybe look at https://www.access-programmers.co.uk...d.php?t=144603 as one of a gazillion examples out there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.