I have a data set where all the dates are in YYYYMMDD and I need to change it to MM/DD/YYYY. Is this possible? I am only a little familiar with Arcade so not sure how to proceed. Any help would be greatly appreciated.
Is it a date field displaying as yyyymmdd or a text field with string values as yyyymmdd? Like text, 20241120.
Do the mm have a 0 for jan-oct e.g. 01, 02
