Forum Discussion

qinglau's avatar
qinglau
Mentor
11 years ago

Control date format output

Hi All,    I would like to display the last login time of users in a date format :    dd-mm-yyyy, like 05-07-2013    I manage to use the REST API call get output : " Dec 12, 2013" <#ass...
  • VarunGrazitti's avatar
    VarunGrazitti
    11 years ago

    qinglau  That is because you are using a hard coded user ID '17' in the latestLogin and in lastVisit, you are using ${user.id} which is the current user.

     

    use this: 

    <#assign latestLogin = restadmin("/users/id/${user.id}/last_visit_time").value?datetime("yyyy-MM-dd'T'hh:mm:ss")?string("dd-MM-yyyy") />
${latestLogin}

     

VarunGrazitti's avatar
VarunGrazitti
Boss

Or, you can even try this:

 

<#assign latestLogin = restadmin("/users/id/17/last_visit_time").value?datetime("yyyy-MM-dd'T'hh:mm:ss")?string("dd-MM-yyyy") />
${latestLogin}

 

qinglau's avatar
qinglau
Mentor
11 years ago

Hi Guys, 

 

Thank you for the quick reply. I have tried this code 

 

<#assign latestLogin = restadmin("/users/id/17/last_visit_time").value?datetime("yyyy-MM-dd'T'hh:mm:ss")?string("dd-MM-yyyy") />
${latestLogin}

 

However, the "lastestLogin"output date is not the same as REST call response:

 

 <#assign lastVisit = restadmin("/users/id/${user.id}/last_visit_time/?restapi.response_style=view").value.@view_date />

 

In REST Call response is 

<response status="success">
<value type="date_time" view_date="17-10-2013" view_time="17:47">2013-10-17T15:47:08+00:00</value>
</response>

 

The output of lastLogin if i remove the "?string("dd-MM-yyy")" is

Aug 2, 2011 8:32:02 AM

 

I guess it must datetime setup format has wrong syntax.  What do u think?

 

Cheers,
Qing

 

  • VarunGrazitti's avatar
    VarunGrazitti
    Boss
    11 years ago

    qinglau  That is because you are using a hard coded user ID '17' in the latestLogin and in lastVisit, you are using ${user.id} which is the current user.

     

    use this: 

    <#assign latestLogin = restadmin("/users/id/${user.id}/last_visit_time").value?datetime("yyyy-MM-dd'T'hh:mm:ss")?string("dd-MM-yyyy") />
${latestLogin}

     

  • nathan's avatar
    nathan
    Executive
    11 years ago

    The view_date property is the date as it would be displayed to the user - importantly the timezone and format are deteremined by the user's settings/locale.

     

    The raw value from the REST API includes the timezone (the '+00:00' bit at the end indicates that the timezone is GMT). The user will see the date/time in their timezone. In your example there is a two-hour difference, probably indicating that the user has an Eastern European locale.