Portal2 - Change DateTime format in Table Portlet

Flow Classic
,
1

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

2

Hi and welcome to the Forum! :slight_smile:

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
image811×843 40.1 KB

3

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
imagem1256×650 78.8 KB

I am using Novacura flow portal2 vers. 2024.1

4

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

5

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
NovacuraFlow1698×600 161 KB

6

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
imagem868×757 29.8 KB

7

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?

8

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
image422×116 1.57 KB

gets me:
image
image380×929 31.2 KB

And if i change to (and log out and in):
image
I get:

image
image401×920 31.6 KB

Now if the locale is not set on Flow user:

image
image429×107 1.46 KB

Then its determined by the language settings of the browser:
image
image1306×446 27.8 KB

image
image395×914 32.6 KB

image
image964×297 13.2 KB

image
image418×939 35.4 KB

DateTime columns follow the same “logic”

image
image365×953 20.3 KB

image
image426×964 23.6 KB

(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 :slight_smile: )

B R
Ivan

1 Like
9

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 :slight_smile:

Thanks all for your support

1 Like