Plumsails Lookup item format

[Mapleleaf]

I have a plumsails lookup-field, which shows the Lookup-item an in addition another column from the target-list. This column ist a date-field.

When I display this date with the item-format Item['Datefield'] it shows the date like "yyyy-mm-ddThh:mm:ssZ".


How can I display the date like dd.mm.yyyy?

[YuriyMedvedev]

Hi! Use this code in Item Format, please:

Code: Select all

function(item) {
  function format(dateString) {
    if(!dateString) return dateString;
    var result = new Date(dateString).toLocaleDateString();
    return result;
  }
  return '<span class="csl-option">' + format(item["{LookupField}"]) + '</span>'
}

[Mapleleaf]

Works great. Thanks.

As I wanted no weekday i changed this line:

var result = new Date(DateString).format("dd.MM.yyyy");