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,
Solved
FSM 6.13 - AdHoc Report Datetime Format
+7Best answer by Hushan Hasarel
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
João Oliveira
+11Hi 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
+7Hi
This works for datetime field, but not for string (even with a masktype).
Thank you,
João Oliveira
1 person likes this
+12Hi
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
1 person likes this
+11Hi
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.