Display User Local Time and Custom Date Format in Cube View Footer
Hello,
We’re trying to display the date and time in the footer of our cube views in the following format:
"Wednesday, April 16, 2025 - 16:27:13" (or "Mercredi 16 avril - 16:27:13" for a user with French culture settings).
We are currently using the |DateTimeHHMMSS| variable, but it shows the server time (e.g., 14:27:13 instead of the user’s local time: 16:27:13).
The native option via Application Properties > Show Date doesn’t meet our needs, as it displays the date in the format "4/16/2025" or "16/4/2025".
We’re looking for a more readable format depending on user culture:
- "Wednesday, April 16, 2025" (EN culture)
- "Mercredi 16 avril" (FR culture)
Does anyone know how to achieve this — displaying both the user’s local time and a culture-based, readable date format in the footer?
Thanks a lot !