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

CarlosRishmawi1 — Thu, 26 Mar 2015 11:55:29 GMT

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

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

RobertScheitlin__GISP — Sat, 11 Dec 2021 14:08:13 GMT

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

topic Re: how can I get/query all the records based on the last date in ArcGIS JavaScript Maps SDK Questions

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

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