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

Hi @Hushan Hasarel ,

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

Thank you,

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

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