I am new to javascript, i am getting date from query, but i want change another formate
$('#example1').DataTable({
"ajax": {
"url": "/txnlist/data",
"data": {"date":[[${date}]]},
"dataSrc": ""
},
"columns": [
{ "data": "id" },
{ "data": "AccountNumber" },
{ "data": "TransactionDate"} // date:032716
],
});
here i am getting date mmddyy,but i want yyyy-dd-mm. How to change it?
You can use the following code as an example:
var yourDate = '032716'; //mmddyy
// keep in mind that 16 is ambiguous as it could be either 1916 or 2016 so parse it properly
var year = '20' + yourDate.substring(4, 6);
var month = yourDate.substring(0, 2);
var day = yourDate.substring(2, 4);
// pass params as yy mm dd
var dateObj = new Date(year, month, day);
var parsedDateObj = dateObj.getFullYear() + '-' + month + '-' + day; // yyyy-dd-mm
console.log(parsedDateObj); // output: 2016-03-27
Try it online on jsfiddle.
Alternatively if you don't mind using a library for that you could use moment js and format it like this:
moment(dateObj).format('YYYY-MM-DD');
209-32-91 my original date is 032917You are a beginner so think it simple. if you go with custom functions you will get confused.
try to use moment.js a timezone js library.
check my answer how i did using moment.js
for your easy understand will split it further,
my_date_format = "032716" // your date in MM(Month)DD(date)YY(2 digit year format)
my_date = moment(my_date_format, "MM-DD-YY") // getting moment date based on your format. here, date is your input date and exisitng format you have
new_date = my_date.format("YYYY-MM-DD") // date you want to format
console.log(new_date)<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.10.1/moment.js"></script>
<div id="example1"></div>
