But how can I force the date picker in my Thinkwise application to output the selected date as yyyy-mm-dd rather than the more human readable (on this side of the big Atlantic puddle) dd-mm-yyyy?
This question is related to my previous topic but the focus shifted from debugging to fixing a specific issue.
To use other format for the date picker, there is an extended property that can be used : “CustomDateMask”. Here you can specify the date format that you want.
THis issue was parked for a while, and now I'm trying to pick it up again.
Looking at the documentation for “CustomDateMask” :
Specifies a custom date mask the GUI uses to show date values. If no CustomDateTimeMask is specified, this mask is also used for the date part of datetime values.
It suggests that it influences how the date is shown in the GUI, but in the GUI it is already shown correctly. Besides, this is an IAM global setting so it should have already been set correctly because other models in the same IAM work correctly.
The problem seems to be that the report is using a DATE instead of a DATETIME. When I run the report in Crystal Report it works correctly BUT there is no date picker while on another report (which works fine from the same TW application) a datetime is used and that does show a datetime picker. It seems to be a Crystal Reports issue after all :(
To use other format for the date picker, there is an extended property that can be used : “CustomDateMask”. Here you can specify the date format that you want.
To use other format for the date picker, there is an extended property that can be used : “CustomDateMask”. Here you can specify the date format that you want.
This would change the way the date picker is presented for all date pickers within the scope of one specific application. If that is what you mean by ‘globally change it', then yes, it would globally change it.
This would change the way the date picker is presented for all date pickers within the scope of one specific application. If that is what you mean by ‘globally change it', then yes, it would globally change it.
That means I need to be carefull and triple check what happens in the rest of the application. I'll have a look.
To use other format for the date picker, there is an extended property that can be used : “CustomDateMask”. Here you can specify the date format that you want.
THis issue was parked for a while, and now I'm trying to pick it up again.
Looking at the documentation for “CustomDateMask” :
Specifies a custom date mask the GUI uses to show date values. If no CustomDateTimeMask is specified, this mask is also used for the date part of datetime values.
It suggests that it influences how the date is shown in the GUI, but in the GUI it is already shown correctly. Besides, this is an IAM global setting so it should have already been set correctly because other models in the same IAM work correctly.
The problem seems to be that the report is using a DATE instead of a DATETIME. When I run the report in Crystal Report it works correctly BUT there is no date picker while on another report (which works fine from the same TW application) a datetime is used and that does show a datetime picker. It seems to be a Crystal Reports issue after all :(
That's unfortunate, @Alban_T. Since you've concluded that it's likely a Crystal Reports issue, do you need any further assistance on this? Or do you still have any questions about this topic?
That's unfortunate, @Alban_T. Since you've concluded that it's likely a Crystal Reports issue, do you need any further assistance on this? Or do you still have any questions about this topic?
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.