I have a 'datetime' column,that when used in a prompt displays the date in ascendind/ descending order. i.e the dates are arranged by year, then by month and then by date.
Now when i display this 'datetime' column as a string in mm/dd/yyyy format in a prompt, the display order is different. i.e...