how can I get/query all the records based on the last date, where date is stored as timestamp format "ie:1705382400000"
Carlos,
Use a SQL Where clause like this
"DateFiledName BETWEEN '3/26/2015 00:00:00' AMD '3/26/2015 23:59:59'"
You can use a function like this in your code to format the date object with date and time:
require: dojo/date/locale
formatDate: function(value){ if(value === '[value]' || value === ''){ return value; } // see also parseDate() // to bypass the locale dependent connector character format date and time separately var s1 = locale.format(value, { datePattern: "yyyy-MM-dd", selector: "date" }); var s2 = locale.format(value, { selector: "time", timePattern: "HH:mm:ss" }); return s1 + " " + s2; },