Hi Gurus,
I have a date field in list whose default format is yyyy-mm-dd.
I want to change the format of the date to mm/dd/yyyy.
In the properties window I selected :
data format-->date and changed pattern/display years/display months/displays days/date ordering etc.
But the format is not changing.
I also converted the field into date data type(assuming the datatype of field is not date) using cast function and changed the data format.
But it also did not work.
Can anyone please suggest me how to achieve this?
Extract DD,MM.YYYY and the concatenate.
Hi,
In Data Format it should be > Long, separator = '/', format should be month day year, show years = Yes, month = 2digits, day = 2digits.
Thanks