Solved

FSM 6.13 - AdHoc Report Datetime Format

  • 22 October 2021
  • 4 replies
  • 167 views
ZRZJOLIVEIRA
Rank
Userlevel 3
Badge +7

Hi,

 

Is it possible to change the datetime format for the AdHoc reports extracted from FSM?

The image below shows the result, but it’s easy to work with this formats at excel

 

Best regrds,

icon

Best answer by Hushan Hasarel 22 October 2021, 18:59

View original
João Oliveira

4 replies

Hushan Hasarel
Rank
Userlevel 4
Badge +10

Hi João,

 

As I know, you can’t change the datetime format in Ad Hoc reports from FSM. But it changes the format to that format used by the client computer’s regional date time formats. You can go to the control panel → Clock and Region and if you change the date and time format from there, I think ad hoc report will show the same format.

 

 

Thanks & Best Regards,

Hushan Hasarel

ZRZJOLIVEIRA
Rank
Userlevel 3
Badge +7

Hi @Hushan Hasarel ,

 

This works for datetime field, but not for string (even with a masktype).

 

Thank you,

 

João Oliveira
SanjeewaJ
Rank
Userlevel 5
Badge +12

Hi @ZRZJOLIVEIRA ,

Why don't you create a database view having all the fields to be included in the report with correct formatting. Since database functions have much more flexibility both in oracle and sql server.

/Sanjeewa

JuniSihombing
Rank
Userlevel 4
Badge +11

Hi @SanjeewaJ ,

if we cannot create a new view with correct format of the date-field, is there any other option?

e.g. is there any possibility to convert the date-field in design-time?

 

Best regards,

~Juni

 

@drooij 

Reply


Terms & ConditionsCookie settings