how can I get/query all the records based on the last date

3358
1
03-26-2015 04:55 AM
CarlosRishmawi1
New Contributor

how can I get/query all the records based on the last date, where date is stored as timestamp format "ie:1705382400000"

0 Kudos
1 Reply
RobertScheitlin__GISP
MVP Emeritus

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