Hi, I am trying to convert a date from Ex., May 5 2019 12:00AM TO M/DD/YYYY format. I have created a list for all 12 months to convert May to a 5 by referencing the Code column in the list of months I made. I now need to pull in the day and year and add the slashes. Can someone please help me with the formula build to pull in the /'s and day and year so the new date will read 5/5/2019?
Also needs to work when the day of the month is a double-digit like, Ex., 5/12/19.
Thanks,