Skip to main content
Question

FSM Smart / Web client date format configuration

  • November 5, 2020
  • 1 reply
  • 279 views

Forum|alt.badge.img+1

Is there any way to define client date format other than workstation region setting? It is wanted that FSM displays date in UK format while the workstation region setting is US. (The whole application)

Mike The FSM TechnoGeek
Superhero (Employee)
Forum|alt.badge.img+17

If there is a way to do this, I don’t think it’s an easy way.  I also don’t think there is really a way to do it for the whole application as you asked.  For a single datetime value, I might have two fields (possibly both non-DB fields) on the screen, one of them the existing UTC datetime and the other a string with a valid time zone name ( sys.time_zone_info  ).  FSM uses these strings, so I don’t think you would need to convert it.  I’d then define a custom Client Script SQL command using T-SQL AT TIME ZONE to return the value in the desired time zone.  This assumes you’re using SQL Server or Azure SQL.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings