Skip to main content

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)

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