# Portal2 - Change DateTime format in Table Portlet

**URL:** <https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880>\
**Category:** Flow Classic\
**Tags:** web-client, portal\
**Created:** [February 27, 2025, 11:39am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880 "2025-02-27T11:39:19Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpinto](https://avatars.discourse-cdn.com/v4/letter/m/7C9FD7/32.png) [@mpinto](https://forum.novacura.com/u/mpinto)\
**Post date:** [February 27, 2025, 11:39am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/1 "2025-02-27T11:39:19Z")

</div>

I’m using a table portlet but I don’t find any way to format the date and time presentation.

The date is being preseted with an American format (like: 3/26/25, 8:21 PM) but I want to change the format for a european format. (like 26/03/25 20:21)

I read in this forum, for a similar topic, but not related with this portlet, that the format presentation is based on the locale of the user, but my locale configuration in windows is portuguese so, it seems that doesn’t apply to this portlet.

How can I change the date/time presentation?  
Thanks

---

<div class="post-metadata">

**Author:** ![Alluse](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/alluse/32/1013_2.png) [@Alluse](https://forum.novacura.com/u/Alluse)\
**Post date:** [February 27, 2025, 12:40pm UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/2 "2025-02-27T12:40:00Z")

</div>

Hi and welcome to the Forum! 🙂

If your date format is setup correctly in Windows and/or your browser, the date displayed in Portal should follow the same format. Can you check if you have “Time Offset” activated in the portal?

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/d3df05dcaad05f3487b0b1aa121f046772bdebc6.png)

---

<div class="post-metadata">

**Author:** ![mpinto](https://avatars.discourse-cdn.com/v4/letter/m/7C9FD7/32.png) [@mpinto](https://forum.novacura.com/u/mpinto)\
**Post date:** [February 27, 2025, 4:57pm UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/3 "2025-02-27T16:57:25Z")

</div>

The “Time Offset” is activated.  
My windows configuration is configured with localization and DateTime format for Portugal.  
I tested with edge, Firefox and Chrome and all show the datetime with american format.  
As you can see by the image below, window has a portuguese datetime format.

 ![imagem](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/e5d4acce1dca9528b2a9ff996de59d2f767965c6.png)

I am using Novacura flow portal2 vers. 2024.1

---

<div class="post-metadata">

**Author:** ![OlaCarlander](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/olacarlander/32/205_2.png) [@OlaCarlander](https://forum.novacura.com/u/OlaCarlander)\
**Post date:** [February 27, 2025, 5:00pm UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/4 "2025-02-27T17:00:14Z")

</div>

Also check what language and locale your user has in flow (under the user administration)

---

<div class="post-metadata">

**Author:** ![mpinto](https://avatars.discourse-cdn.com/v4/letter/m/7C9FD7/32.png) [@mpinto](https://forum.novacura.com/u/mpinto)\
**Post date:** [March 3, 2025, 11:42am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/5 "2025-03-03T11:42:47Z")

</div>

Hello,  
The language in flow is also with Portuguese format and, in the flow configuration, the datetime format that is presented is the portuguese one.

 ![NovacuraFlow](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/168e7c2af85af8cbadc4cbcc9aaae26f96964949.jpeg)

---

<div class="post-metadata">

**Author:** ![mpinto](https://avatars.discourse-cdn.com/v4/letter/m/7C9FD7/32.png) [@mpinto](https://forum.novacura.com/u/mpinto)\
**Post date:** [March 3, 2025, 11:55am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/6 "2025-03-03T11:55:03Z")

</div>

Summarising the problem: I have tested the table portlet in different machines with different users but in all the date time is presented with the american format (like: 2/26/25, 8:21 PM)

In the novacura local server, in the flow user configuration i can see the portuguese datetime format (like 26/02/25 20:21) but even in this machine the table portlet presented in the browser in with the american format.

Can this be a problem of my version?

 ![imagem](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/9f24f27530b8146cb5c1695665e7222ef9a4fb9d.png)

---

<div class="post-metadata">

**Author:** ![OlaCarlander](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/olacarlander/32/205_2.png) [@OlaCarlander](https://forum.novacura.com/u/OlaCarlander)\
**Post date:** [March 4, 2025, 7:38am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/7 "2025-03-04T07:38:20Z")

</div>

It could be worth upgrading, as a few newer versions are out there now.

But also, what happens if you display the data as text (not datetime)? Are you using flow as a data source, or querying a database directly from the portal?

---

<div class="post-metadata">

**Author:** ![ivstde](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/ivstde/32/146_2.png) [@ivstde](https://forum.novacura.com/u/ivstde)\
**Post date:** [March 6, 2025, 11:05am UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/8 "2025-03-06T11:05:02Z")

</div>

Hi,  
i believe that date display format of table portlet date type columns is determined by locale setting of the Flow user  
So this:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/7445d680a6f85a0ef46c1988687431a82280ace5.png)  
gets me:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/b8b96f3c42a06a937cbefad5bb48957a8a9e9dbc.png)

And if i change to (and log out and in):  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/d85b7310b0446aba3c4216914b4c1a9203491679.png)  
I get:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/69cc6c5fe2894e852cea69612ff2b79f397f9416.png)

Now if the locale is not set on Flow user:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/405d6ffbcc2ee0f73f873d7d25146f47fecce068.png)  
Then its determined by the language settings of the browser:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/e0dd957f6feb4b7d3f5dd216b0e16d5676e0d407.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/d129e9f7be0bd25193c1ce1c32105fc3d8d8e2f5.png)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/91e2f0003552cfd0e7e6f62d5575f1601a3cf8e0.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/adae811d8a39cf8cc38d04348ccee693b1d28a5d.png)

DateTime columns follow the same “logic”

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/b868061bfacb9b56d5a65ef6c2a9ef48fe17298b.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/bff1f7e6caa8eae7d2d1b23b3d821ac17ab61b9d.png)

(This is on Portal2 2024.4.29 but i think thats how it worked on previous versions too)

Hope this helps!  
(Also…just now i noticed my Windows date format / locale is set to US all along…thats…just wrong 🙂 )

B R  
Ivan

---

<div class="post-metadata">

**Author:** ![mpinto](https://avatars.discourse-cdn.com/v4/letter/m/7C9FD7/32.png) [@mpinto](https://forum.novacura.com/u/mpinto)\
**Post date:** [March 18, 2025, 5:13pm UTC](https://forum.novacura.com/t/portal2-change-datetime-format-in-table-portlet/880/9 "2025-03-18T17:13:38Z")

</div>

Hello @ivstde, thanks for your detailed answer.  
Because the same test you did was not working with me, I have upgraded Novacura for the latest version (which happened only today) but even with the new version Novacura was not presenting the DateTime with the portuguese format

So, I tried with the uk location and… surprise, it worked.  
So, it seems that **Novacura don’t have the configuration for the Portuguese datetime format**. As workarround, we are now configuring the users to be located in uk 🙂

Thanks all for your support
