Hi,
I am trying to change the date retrieved from database and format it into "dd/mm/yyyy".
I tried input this ("$.datepicker.formatDate('dd/mm/yy', new Date(value));" and "return $.format.date(value, "dd MMMM, yyyy");" into the js in the mapping, however it does not work.
Is any problem with my coding? How can I accomplish this?
Rui,
Please add next for label_date in the js:
prevar date = value.split(" ");
var date_parts = date.split("-");
return date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0]/pre
Hi,
I tried to put it in into the js just like what you told me to, but I still get the same result.
Hello,
1) in DB event_date column has correct value
2) Could you add console.log(date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0]);
before return, and open console while testing?
It is looks like you have a cache problem.
Hi,
This is the error I get, please advise thanks!
Hi Rui,
".split" functionality return an array.
But you use it like string.
See details here: http://prntscr.com/61nf4c/direct
Regards.
Hi,
Thank you so much, I manage to display what I want.
For those who need it, this is a way to achieve it:
"var date = value.split(" ");
var date1 = date[0];
var date_parts = date1.split("-");
return date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0];".
Hello Rui,
Thank you for the update, glad it works!
Hello.
Thank you for the tips on date formatting.
How to add to beside date time in following format dd/mm/yyyy - hh:mm
Thank you in advance.
Hello Ilya,
date[1] - has time frame of datetime.
return date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0] + " - " + date[1];