The format varies between YYYYMMDD and YYYYMMDDHHMM. The data comes from our partner hospital, so I am not sure why some have hours and minutes and others do not.
Thank you for pointing me in the right direction. I would prefer to do this pre-Xlate, but my tcl is limited. I do hope someone can provide something for me to pay with. In the mean time I will work on the Xlate.
