Forum Discussion

no_one_but_me's avatar
no_one_but_me
Frequent Visitor
5 years ago

Can I display the date and time column according to users location?

I have a data which is a "SharePoint Online" as source and I need a display a date and time column in the table visual

 

Currently I am displaying data in the PST format for "US" if users location is in  US and BST if the users location is "UK" The problem is I am displaying US and UK timezone in a single date/time column i.e..,

 

LocationDate and Time
US06/31/2021 05:30 AM + 8:00
UK06/10/2021 07:30 AM + 1:00

 

But The requirement is the "Date and Time" column should be displayed according to the users current location whenever they login 

It should be in a single column with their own timezones and that should be dynamic It should get the users location and query the data accordingly

 

For Example:

 

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM 
JustinUK05/10/2021 07:30 AM 

 

When Sarah logins and check for the report the result of the Date and Time should be like below:

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM+8:00
JustinUK05/10/2021 07:30 AM + 8:00

 

When Justin logins and check the report the result of the Date and Time should be like below:

UsernameLocationDate and Time
SarahUS06/31/2021 05:30 AM+1:00
JustinUK05/10/2021 07:30 AM + 1:00

 

Can I display it as above . If yes,please do help me

 

Thanks in advance

4 Replies