I'm trying to find the best way to create a function to create a date in the format of MM/DD/YYYY from MMDDYYYY. I've looked around but haven't been able to find anything that works. I've tried convert() and a couple of other things but it doesn't recognize that format as a date. I can't get the format that's provided changed.
Thanks in advance for any help.