I am trying to change the format of the date on my report (dd-mm-yy e.g. 15-oct-24) to format MM/DD/YYYY. I tried using the DateTime tool but I am getting Null. Can someone please help?
You can alternatively use this formula in workflow = DateTimeFormat(DateTimeParse([DateField], "%d-%b-%y"), "%m/%d/%Y") for achieving desired result