Legacy Knowledge Base
Published Jun. 30, 2025

Inconsistency of the user's LoginDate in the exported CSV file

Written By

Anushka Tiwari

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

  • Getting inconsistent user login date format in CSV file after exporting the users.
  • Steps to reproduce:
  1. Add the last login date to the portal-ext.properties file, and reference the article for the same: Include more user attributes when exporting users to a CSV file.
  2. Start Liferay Portal 6.2 SP20 contains liferay-fixpack-portal-154-6210. Navigate to Admin > Users > Add Members > Users, and add the users.
  3. Now, navigate to the Admin > Control Panel > Users and Organization > All Users.
  4. Export the users and save the CSV file.

Observed Behavior: After exporting the users in the CSV file, the date is visible in the incorrect format. However, in the first attempt, it shows the incorrect date. In the second attempt, it shows the correct date format.
Correct date format: Wed Sep 13 06:45:47 GMT 2023
Incorrect date format: 2023-09-13 06:09:21.857

Environment

  • Liferay Portal 6.2

Resolution

  • The observed behavior is a known bug addressed by the LPE-15967 and has already been included in liferay-fixpack-portal-155-6210.

Additional Information

Did this article resolve your issue ?

Legacy Knowledge Base