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;
},