nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date format in a DataGrid

KatBrenkert

Is there an example anywhere of how to format a date field for a datagrid? I've tried calling a labelFunction but anytime I apply a dateformatter using code I get nothing returned. I've tried a few variations of the code below.

public function getDateLabel(item:Object,column:DataGridColumn):String 
{
return dateFormat.format(item[column.dataField]);
}

Vind meer berichten getagd met

Accepted answers

All comments

KatBrenkert

I changed the code to read:

date.milliseconds=date.milliseconds + 86400000; \\adds a day

I also took out the if statement to force it to add a day every time. I'm not too happy with this fix, but it's been the only thing to get my dates to actually show up correctly in this application. Every other web app I have programmed I add a millisecond and its works fine.

KatBrenkert

I installed the service pack this morning but I still have the date problem.

rscheitlin

Kathleen,

Are you running ArcGIS Server SP1?

KatBrenkert

Thanks Robert it's just what I needed. The only problem I have now is it's not catching the rest date bug and all my dates are coming up as 1 day early. Can you tell what I've done wrong with my msToDate code?

private function msToDate(ms:Number, dateFormat:String):String
   {
    var date:Date= new Date(ms);
    if (date.milliseconds==999)
    {
     date.milliseconds++;
     
    }
    if (dateFormat)
    {
     var result:String=mydateFormat.format(date);
     if (result)
     {
      return result;
     }
     else
     {
      return dateFormat;
     }
    }
    else
    {
     return date.toLocaleString();
    }
   }

rscheitlin

Kathleen,

Yep, I did forget to include that 😮

   private function msToDate(ms:Number, dateFormat:String):String
   {
    var date:Date = new Date(ms);
    if (date.milliseconds == 999) // workaround for REST bug
    {
     date.milliseconds++;
    }
    
    if (dateFormat)
    {
     dateFormatter.formatString = dateFormat;
     var result:String = dateFormatter.format(date);
     if (result)
     {
      return result;
     }
     else
     {
      return dateFormatter.error;
     }
    }
    else
    {
     return date.toLocaleString();
    }
   }

KatBrenkert

is the msToDate a function you have written? I get an error on that line. I'm guessing it's a millisecond to date function?

rscheitlin

Kathleen,

Here is my date label function:

private function getDateLbl(item:Object,column:DataGridColumn):String
   {
    var dateMS:Number = Number(item[column.dataField]);
    var retVal:String = "";
    var rVal:String = item[column.dataField];
    if(rVal == null)
    {
     //do nothing
    }else{
     if (!isNaN(dateMS))
     {
      retVal = msToDate(dateMS, _dateFormat);
     }
    }
    return retVal;
   }

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.