I have a csv file that date is displayed as '26-Oct-20' .But when click on the value, the formula bar will show it as 10/26/2020. How can I format the cell so it will display as '26-Oct-2020' in the cell? I've tried the code
date1 := date(collection_date,"%d-%b-%Y"); but it did not work.
The time field in the file is in 24 hours format. so in the csv file, the value is '13:10'. How can I format it so the time is displayed as '1:10 PM'? Thank you for reading the post!