Unix timestamp convert to Gregorian | Community
Skip to main content
New Member
October 24, 2019

Unix timestamp convert to Gregorian

  • October 24, 2019
  • 2 replies
  • 2296 views

Hi,

I have created Site Page to display Form ID (in CRX - formID) and to display last modify date from metadata (in CRX jcr:LastModified). These are out of the box metadata information. The page is able to display but the display data does showed up on Unix timestamp (eg. 1571836800000) and not Gregorian (eg. 10-23-2019 08:20). The properties that I am editing are in template.html property through CRXDE Lite( apps/fd/fp/<folder>/template.html ). Is there a way to display information in Gregorian format? Thanks.

Below is an example of template.html.

<table class="m-tab __FP_grid-table __FP_single-color" width="100%" style="table-layout:fixed;" cellpadding="0" cellspacing="0" border="0">
    <thead>
        <tr>
            <th class="__FP_grid_overflow-control-th __FP_grid-name __FP_grid_sort" tabindex="0" data-sortKey="formid">Form ID</th>
            <th class="__FP_grid_overflow-control-th __FP_grid-description __FP_grid_sort" tabindex="0" data-sortKey="jcr:lastModified">${localize-jcr:lastModified}</th>
            <th class="__FP_grid_overflow-control-th __FP_grid-description" tabindex="0">${localize-Actions}</th>
        </tr>
    </thead>
    <tr data-repeatable="true">
        <td class="__FP_grid_overflow-control" title="${formid}" tabindex="0" data-label="${localize-Form ID}">${formid}</td>
<td class="__FP_grid_overflow-control" title="${description}" tabindex="0" data-label="${localize-jcr:lastModified}">${lastModified}</td>

        <td class="__FP_grid_open-download-image" data-label="${localize-Actions}">
            <a style="cursor:pointer;" onclick="javascript:window.open('${formUrl}', '_blank');" class="__FP_panel-html-open ${htmlStyle}" title="${config-htmlLinkText}"></a>
            <a href="https://forums.adobe.com/lc/bin/acsforms/render/renderextend?xdppath=${path}" target="_blank" class="__FP_panel-pdf-open ${pdfStyle}" title="${config-pdfLinkText}"></a>
        </td>
    </tr>
</table>

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Adobe Employee
October 28, 2019

Is your question similar to HTL AEM 6.3 DateFormat ? Then the answer may be using the format option like this: ${'dd-MM-yyyy' @ format=lastModified}

I tested :

'dd-MM-yyyy' @ format=properties.jcr:created is ${'dd-MM-yyyy' @ format=properties.jcr:created}

which renders as:

'dd-MM-yyyy' @ format=properties.jcr:created is 14-11-2018

New Member
November 13, 2019

Close enough. Did some experiment and seem to get what I needed. Thank you.